You execute the following query to check resource consumption in the current plan used by the database:

SQL> SELECT name,active_sessions,requests,queue_length,current_undo_consumption "UNDO CONSUMPTION" FROM V$rsrc_consumer_group; NAME ACTIVE_SESSIONS REQUESTS QUEUE_LENGTH UNDO CONSUMPTION --------------- ------------------------ -------------- OTHER_GROUPS 1 1 0 GROUP1 2 4 2 Which statement is correct when a user belonging to GROUP1 tries to start a session?

Question

You execute the following query to check resource consumption in the current plan used by the database:

SQL> SELECT name,active_sessions,requests,queue_length,current_undo_consumption "UNDO CONSUMPTION" FROM V$rsrc_consumer_group; NAME ACTIVE_SESSIONS REQUESTS QUEUE_LENGTH UNDO CONSUMPTION --------------- ------------------------ -------------- OTHER_GROUPS 1 1 0 GROUP1 2 4 2 Which statement is correct when a user belonging to GROUP1 tries to start a session?

Accepted Answer

A. The user can login but the session will be queued.

Answer

B. The user's attempt to start a session fails with an error.

Answer

C. The session starts successfully and allows all the operations.

Answer

D. The session starts successfully but cannot perform data definition language (DDL) operations.

Answer

E. The session opens successfully but cannot perform data manipulation language (DML)

You execute the following query to check resource consumption in the current plan used by the database: SQL> SELECT name,active_sessions,requests,queue_length,current_undo_consumption "UNDO…

Question

Options

How the community answered

Community Discussion