Which two statements are true about scheduling operations in a pluggable database (PDB)?

A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

B. A job defined in a PDB runs only if that PDB is open.

C. Scheduler attribute setting is performed only at the CDB level.

D. Scheduler objects created by users can be exported or imported using Data Pump.

E. Scheduler jobs for a PDB can be created only by common users.

Which three types of failures are detected by the Data Recovery Advisor (DRA)?

A. loss of a non-critical data file

B. loss of a control file

C. physical data block corruption

D. logical data block corruption

E. loss of an archived redo log file

Examine the command to create a pluggable database (PDB):

SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1

FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX = '/disk2/oracle/

pdb2';

Which two statements are true?

A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.

B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.

C. The tablespace specifications of pdb2 are the same as pdb1.

D. All database objects belonging to common users in PD3I are cloned in PD32.

E. pdb2 is created with its own private undo and temp tablespaces.

In a database supporting an OLTP workload, tables are frequently updated on both key and nonkeycolumns.

Reports are also generated by joining multiple tables.

Which table organization or type would provide the best performance for this hybrid workload?

A. heap table with a primary key index

B. external table

C. hash clustered table

D. global temporary table

E. index clustered table

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A. A base recovery catalog should exist.

B. The owner of VPC cannot own recovery catalog.

C. At least one target database should be registered in the recovery catalog.

D. The register database privilege should be granted to the virtual catalog owner.

E. The DBA role should be granted to the virtual catalog owner.