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 resources consumed by a database instance whose current Resource Manager plan is displayed.

SQL> SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;

Which two statements are true?

A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.

C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.

D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

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