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; NAME CPU_WAIT_TIME ACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_TIME CPU_WAITS OLTP_ORDER_ENTRY 6709 1 0 29690 467 OTHER_GROUPS 60425 0 0 5982366 4089 SYS_GROUP 19540 1 0 2420704 914 DSS_QUERIES 55700 4 2 4594660 3004 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.

Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 8 of 40

Marks: +1, -0

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;

NAME CPU_WAIT_TIME	ACTIVE_SESSIONS	QUEUE_LENGTH	CONSUMED_CPU_TIME	CPU_WAITS
OLTP_ORDER_ENTRY 6709	1	0	29690	467
OTHER_GROUPS 60425	0	0	5982366	4089
SYS_GROUP 19540	1	0	2420704	914
DSS_QUERIES 55700	4	2	4594660	3004

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.

Validate

Go to Question:

Prev Question

Next Question