Which two statements are true about clean restore points in a regular PDB? (Choose two.)

A. They require a clone instance to be created when used in a PDB flashback operation

B. They can be created for a PDB when connected to either the PDB or to the root

C. They require backups to be restored when used in a PDB flashback operation

D. They are created as guaranteed restore points

E. They can be created only if shared undo is enabled

F. They can be created only for a PDB in the mount state

Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database 12c Release 2.

A. The COMPATIBLE parameter must be set to 12.0 or greater.

B. The database must be in ARCHIVELOG mode.

C. FLASHBACK DATABASE must be enabled.

D. RMAN must use a recovery catalog.

E. The database must be in the READ WRITE state.

F. RMAN can recover the table only from a backupset.

G. An export dump file of the table must be available.

H. There must be sufficient space to start the auxiliary instance.

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?

A. for parallel query performance only

B. for query performance and space saving

C. for query performance and space saving with greater bias toward space saving

D. for query performance only

E. for space saving only

One of your databases supports an OLTP workload.

If a better plan is discovered for a statement, then you want that plan to be used.

Which two can cause better plans to be used for a statement? (Choose two.)

A. adaptive cursor sharing

B. using literals in SQL statements

C. SQL Access Advisor

D. SQL Performance Analyzer

E. adaptive execution plans

Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

A. subpartitions

B. clustered tables

C. materialized views

D. index-organized tables

E. heap tables

F. any SYS owned objects