Upgrade Oracle DBA 11g or 12c to 12c R2: 1Z0-074

Examine this command:

Which statement is true?

A. Up to four worker processes are allocated to export data and metadata

B. Four worker processes are allocated to export only data

C. Four worker processes are active to export only metadata

D. Four worker processes are allocated to export data and metadata

E. Four worker processes are allocated when there is sufficient CPU available

Identify a situation where performance profiles can be used for application containers.

A. to specify the total number of parallel execution servers available

B. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out

C. to specify the maximum percentage of the parallel execution server pool that a particular application container can use

D. to enforce a limit on the number of I/OS issued per second

E. to enforce a limit on I/O throughput per second

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A. number of parallel queries issued by a consumer group

B. maximum number of DML operations performed by a consumer group

C. sessions that are blocking other sessions

D. sessions that are not blocking other sessions

E. UNDO quota for a consumer group