A.A PDB snapshot is always a sparse copy of the source PDB.

B.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

C.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

D.A PDB snapshot is always a full copy of the source PDB.

E.A snapshot copy PDB can be created from a stand-alone clone PDB.

F.A PDB snapshot depends on a storage snapshot which can be stored on any file system.

G.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

A.It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

B.It checks each query being analyzed for stale statistics.

C.It considers all SQL statements being analyzed by the advisor task as a group.

D.It checks each query being analyzed for missing statistics.

E.It only recommends syntactic changes to SQL statements.

F.It can recommend semantic changes to SQL statements.

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 a set of recommendations by the optimizer to create new indexes.

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

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

A.Data file 24 must be recovered while the CDB is opened.

B.Data file 24 cannot be recovered while the CDB is opened.

C.Data file 24 must be recovered while PDB2 is closed.

D.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

E.Data file 24 can be recovered while PDB2 is opened.

A.Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

B.Recovery begins from the beginning of the CURRENT redo log group.

C.Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

D.Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

E.Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

F.Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.