Oracle Database 11g: Administration Workshop I: 1Z0-052

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

A. It is maintained by executing the PL/SQL procedures in the DBMS_STATS package.

B. It includes statistics that contain the number of distinct values per table column.

C. It includes statistics that contain the number of rows per table.

D. AWR data is stored in the SYSAUX tablespace.

E. Automatic AWR snapshots are created by the Manageability Monitor (MMON) background process.

F. By default, AWR data is retained for eight days.

User A executes the following command to drop a large table in your database:

SQL> DROP TABLE trans;

While the drop table operation is in progress; user B executes the following command on the same table;

SQL> DELETE FROM trans WHERE tr_type='SL';

Which statement is true regarding the DELETE command?

A. It fails to delete the records because the records are locked in the SHARE mode

B. It deletes the rows successfully because the table is locked in the SHARE mod

C. It fails to delete the records because the table is locked in EXCLUSIVE mode

D. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.

What must this name be made up of?

A. It must be made up of a database name and a domain name.

B. It must be made up of the value in ORACLE_SID and HOSTNAME.

C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.