Upgrade Oracle DBA 11g to Oracle Database 12c — Question 45

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 designed to manage resource allocation, making options B and E valid as they pertain to user sessions and their limits. Options A, C, and D refer to other types of resource management that are not specifically addressed by the Database Resource Manager's primary functions.