Oracle Database 12c: Installation and Administration — Question 135

Which three statements are true about Database Resource Manager? (Choose three.)

Answer options

• A. A resource plan change can be automated by using the Oracle Scheduler.
• B. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.
• C. It can be used to control the usage of the undo tablespace by consumer groups.
• D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.
• E. It can be used to enable resumable timeout for user sessions.
• F. It can be used to control the usage of the temp tablespace by consumer groups.

Correct answer: A, C, D

Explanation

Option A is correct because the Oracle Scheduler can automate resource plan changes, enhancing efficiency. Option C is also accurate as Database Resource Manager can manage undo tablespace usage effectively. Option D is correct since a resource plan can indeed contain multiple directives for different consumer groups. Options B, E, and F are incorrect as they either misrepresent the capabilities of Database Resource Manager or relate to features not specifically managed by it.