Oracle Database 12cR2 Administration: 1Z0-072

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)

A. AWR snapshots must be deleted when no longer required by ADDM.

B. ADDM can recommend shrinking the buffer cache.

C. By default, MMON creates an AWR snapshot every 30 minutes.

D. ADDM can recommend extending the buffer cache.

E. By default, AWR snapshots are automatically purged after eight days.

F. ADDM performs its analysis only whenever a DBA requests it.

orcl.dmp contains a full export of the ORCL database.

This command is executed to load data from orcl.dmp into the TESTDB database:

Which two are true? (Choose two.)

A. It skips only tables that exist in both ORCL:SH and TESTDB:HR.

B. It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.

C. It skips all indexes of ORCL:SH and ORCL:OE.

D. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

E. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

Which two are true about direct path load?

A. It enforces only primary key, unique, and not NULL, constraints.

B. DML statements may occur on tables being loaded.

C. It fires insert triggers, if any.

D. It writes only to blocks above the high-water mark.

E. It uses the database buffer cache.