Oracle Database 11g: Administration I - 1Z1-052 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What can you achieve by implementing reverse key index?

A. Reverse the bytes of each column indexed including the row ID B. Remove repeated key values from the index to fit more index entries in a given amount of disk space C. Prevent contention on the highest leaf block when using sequences to generate keys D. Store a bitmap for each key value instead of a list of row IDs in the leaf node

Discussion 0

Correct Answer: C Vote an answer

Question 2

Examine the command that is used to create a table:
SQL> CREATE TABLE orders (
oid NUMBER(6) PRIMARY KEY,
odate DATE,
ccode NUMBER (6),
oamt NUMBER(10,2)
) TABLESPACE users;
Which two statements are true about the effect of the above command? (Choose two.)

A. A CHECK constraint is created on the OID column. B. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace. C. The ORDERS table is the only object created in the USERS tablespace. D. A NOT NULL constraint is created on the OID column. E. The ORDERS table and a unique index are created in the USERS tablespace.

Discussion 0

Correct Answer: D,E Vote an answer

Question 3

You executed the following command to perform a backup of the USERS tablespace:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
ALTER TABLESPACE users BEGIN BACKUP
* ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
What could be the reason for this error?

A. The tablespace is already in backup mode. B. The database is in NOARCHIVELOG mode. C. The MTTR Advisor is disabled. D. The Flash Recovery Area is not configured.

Discussion 0

Correct Answer: B Vote an answer

Question 4

The tnsnames.ora file has an entry for the service alias ORCL as follows:
ORCL
( DESCRIPTION
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(CONNECT_DATA
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
)
)
The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?

A. The orcl.oracle.com database service is not registered with the listener. B. The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file. C. The listener is not running on the database node. D. The TNS_ADMIN environmental variable is set to a wrong value.

Discussion 0

Correct Answer: A Vote an answer

Question 5

You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.
View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction?
Exhibit:

A. Alter the constraint to NOVALIDATE state before starting the transaction B. Set the constraint to deferred before starting the transaction C. Enable the resumable mode for the session before starting the transaction D. Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

A. The leaf block containing the row to be updated is marked as invalid. B. The index becomes invalid after the update. C. An update in a leaf row takes place. D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.

Discussion 0

Correct Answer: D Vote an answer

Question 7

In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?

A. Optimizer statistics are collected automatically. B. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. C. Snapshots cannot be collected manually by using the
DBMS_WORKLOAD_REPOSITORY package. D. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. E. Only timed operating system (OS) statistics and plan execution statistics are collected.

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which four are true about the tools used to administer Oracle databases? (Choose four.)

A. SQL *Plus can be used to start up Oracle instances B. SQL *Plus can be used to create databases C. DBCA can be used to upgrade databases D. RMAN can be used to start up Oracle instances E. Data Pump can be used to load data from text files F. SRVCTL can be used to shut down Oracle instances

Discussion 0

Correct Answer: A,B,C,D Vote an answer

Question 9

You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile.
Some user sessions are currently connected to the database instance and are using the APP_USER profile.
This command is used to drop the profile:
SQL> DROP PROFILE app_user;
Which statement describes the result?

A. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile. B. The command produces an error. C. The profile is dropped and current user sessions use the DEFAULT profile immediately.

Discussion 0

Correct Answer: B Vote an answer

Question 10

Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)

A. Checkpoint information will not be written to the alert log file B. The SGA advisor will be disabled C. Automatic checkpoint tuning will be disabled D. The MTTR advisor will be disabled

Discussion 0

Correct Answer: C,D Vote an answer