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

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.

You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceed during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation. How would you achieve this?

A. Implement a Database Resource Manager plan

B. Implement a profile for these users

C. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions

D. Specify the maximum amount of quota a user can be allocated in the undo tablespace