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. Only timed operating system (OS) statistics and plan execution statistics are collected.

C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.

E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)

A. Running a query on a table returns "ORA-600: Internal Error."

B. Inserting a value in a table returns "ORA-01722: invalid number."

C. Creating a table returns "ORA-00955: name is already used by an existing object."

D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

E. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."

Which of these is true about undo tablespace?

A. Undo tablespace is a temporary tablespace

B. Undo tablespace has only one datafile

C. Undotablespace has a datafile which is reused in cyclic manner

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.

You executed the following commands to find the location of the alert log file:

Where is the alert log file stored? (Choose all that apply.)

A. in the BACKGROUND_DUMP_DEST location; in text format

B. in the BACKGROUND_DUMP_DEST location; in XML format

C. in the BACKGROUND_DUMP_DEST location; in both text and XML format

D. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format

E. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format

F. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format