1Z0-062 · Question #250
Which three statements are true about Database Resource Manager?
The correct answer is A. A resource plan change can be automated by using the Oracle Scheduler. 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. This question tests knowledge of Oracle Database Resource Manager capabilities, focusing on its ability to control various system resources and integrate with other Oracle features.
Question
Which three statements are true about Database Resource Manager?
Options
- AA resource plan change can be automated by using the Oracle Scheduler.
- BIt can be used to control the consumption of only physical I/Os where excessive physical I/Os
- CIt can be used to control the usage of the undo tablespace by consumer groups.
- DA resource plan can have multiple resource plan directives, each of which controls resource
- EIt can be used to enable resumable timeout for user sessions. F. It can be used to control the
How the community answered
(28 responses)- A96% (27)
- E4% (1)
Why each option
This question tests knowledge of Oracle Database Resource Manager capabilities, focusing on its ability to control various system resources and integrate with other Oracle features.
Oracle Database Resource Manager plans can be programmatically switched or activated at specific times by integrating with Oracle Scheduler, allowing for automated resource management based on time-of-day or other criteria.
Database Resource Manager controls a broad range of resources, including CPU, logical I/O, parallel execution, and undo space, not just physical I/Os, and the statement is truncated indicating a limitation.
Database Resource Manager provides the UNDO_POOL directive, which allows administrators to set limits on the amount of undo space that transactions within a specific consumer group can consume, preventing single groups from exhausting undo resources.
A resource plan is composed of one or more resource plan directives, where each directive specifies how a resource is allocated among consumer groups, subplans, or the OTHER_GROUPS catch-all.
Resumable space allocation timeout is a session or system parameter controlled by RESUMABLE_TIMEOUT, which is independent of Database Resource Manager's functionality.
Concept tested: Oracle Database Resource Manager features
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-resources-with-oracle-database-resource-manager.html#GUID-35B12EC1-6EAE-460B-8830-179361660A9C
Topics
Community Discussion
No community discussion yet for this question.