Oracle Database 12c: Advanced Administration — Question 108

For which two requirements would you use the Database Resource Manager?

Answer options

• A. limiting the CPU used per database call
• B. specifying the maximum number of concurrent sessions allowed for a user
• C. specifying the amount of private space a session can allocate in the shared pool of the SGA
• D. limiting the degree of parallelism of operations performed by a user or group of users
• E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Correct answer: B, E

Explanation

The Database Resource Manager is primarily used to manage resources such as concurrent sessions and idle session limits. Option B is correct because it addresses the limitation of concurrent sessions for a user, while option E is correct as it pertains to limiting idle time for blocking sessions. Options A, C, and D, while relevant to resource management, do not specifically fall under the primary functions of the Database Resource Manager.