Q1. Which two statements are true regarding B-tree index? (Choose two.)

A. The leaf blocks in the index are doubly linked.

B. The leaf node stores a bitmap for each key value.

C. The rows with NULL value in key columns also have entries in the index.

D. The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.

View Answer

Q2. The instance abnormally terminates because of a power outage.

Which statement is true about redo log files during instance recovery?

A. Inactive and current redo log files are required to accomplish recovery

B. Online and archived redo files are required to accomplish instance recovery

C. All redo log entries after the last checkpoint are applied from redo log files to data files

D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

View Answer

Q3. Which three statements are correct about temporary tables? (Choose three.)

A. Indexes and views can be created on temporary tables.

B. Both the data and the structure of temporary tables can be exported.

C. Temporary tables are always created in a user's temporary tablespace.

D. The data inserted into a temporary table in a session is available to other sessions.

E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

View Answer

Q4. The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:

SQL> INSERT INTO cust VALUES(101, 'JACK');

1 row created.

SQL> INSERT INTO cust VALUES(102, 'SMITH');

1 row created.

As a DBA, you execute the following command from another session:

ALTER TABLESPACE sales READ ONLY;

Which statement is true regarding the effect of this command on the transaction in Scott's session?

A. The command fails as a transaction is still pending.

B. The transaction in Scott's session is rolled back and the tablespace becomes readonly.

C. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

D. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

View Answer

Q5. In which situation would you use static database registration for a listener?

A. When multiple databases are to be registered with the listener

B. When DBAs need to connect remotely to start up the database instance

C. When users need to connect the database instance using the host naming method

D. When the database instance that is to be registered with the listener is configured in shared server mode

View Answer

Q6. Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)

A. Use the Active Session History report.

B. Use the AWR Compare Periods report.

C. Use an ADDM analysis between 7 PM and 9 PM of the previous day.

D. Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.

View Answer

Q7. Note the following structures in your database server:

1. Extents

2. OS Blocks

3. Tablespace

4. Segments

5. Oracle Data Block

Which option has the correct arrangement of these structures from the smallest to the largest?

A. 2, 5, 1, 4, 3

B. 1, 2, 3, 4, 5

C. 5, 2, 1, 3, 4

D. 2, 1, 5, 4, 3

View Answer

Q8. A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?

A. Set REMOTE_OS_ROLES to FALSE

B. Set OS_ROLES parameter to FALSE

C. Set the REMOTE_OS_AUTHENT parameter to FALSE

D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE

View Answer

Q9. Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

A. Host naming method

B. Local naming method

C. External naming method

D. Directory naming method

View Answer

Q10. Identify two situations in which the block header grows in a data block. (Choose two.)

A. When row directories need more row entries

B. When there is row migration in the data block

C. When there is an increase in the PCTFREE value for the data block

D. When more transaction slots are required than are initially configured

View Answer