Test Index

Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 8

Total: 40

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? (Choose two.)

An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
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 enqueuecontention.
A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

Go to Question:

Prev Question

Next Question