Oracle
1Z0-067 · Question #155
1Z0-067 Question #155: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #155. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- AAn attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
- BAn attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
- CThe CPU_WAIT_TIME column indicates the total time that sessions in the consumer group
- DThe CPU_WAIT_TIME column indicates the total time that sessions in the consumer group
- EA user belonging to the DSS__QUERIES resource consumer group can create a new session but
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.