A.It is performed automatically while the database remains in MOUNT state. Then the database is opened.

B.Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

C.It is not possible if an archived log is missing.

D.It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

E.Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

F.It is performed by the Recovery Writer (RVWR) background process.

A.It is the only possible backup type for a database in NOARCHIVELOG mode.

B.It can be created only by using RMAN.

C.It can be consistent.

D.It can consist of either backup sets or image copies.

E.It can be inconsistent.

F.It always includes all data files, the current control file, the server parameter file, and archived redo logs.

A.All metrics are instance related.

B.Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

C.A space usage management alert is automatically cleared after the underlying problem is resolved.

D.They are generated by SMON when a tablespace is 97% full.

E.Metrics are statistical counts for a specific unit.

F.STATISTICS_LEVEL must be set to ALL to generate alerts.

A.It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.

B.It is a set of recommendations by the optimizer to change the access methods used.

C.It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

D.It is a set of recommendations by the optimizer to create new indexes.

E.It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.

A.Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

B.Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.

C.Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

D.A new PDB is automatically created when importing a non-CDB into a CDB.

E.Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.

F.Moving data from a non-CDB to a PDB is only possible by using conventional export and import.