11.9. Review Questions
Which system privileges allow you to administer the Database Resource Manager?
DBA
ADMINISTER_ANY_RESOURCE
ADMINISTER_RESOURCE_MANAGER
RESOURCE_MANAGER_ADMIN
All of the above
When creating a plan directive, which of the following resource allocation methods are valid when the target of the directive is a sub-plan?
Execution time limit
Undo pool
Automatic consumer group switching
Canceling SQL and terminating sessions
CPU method
Which of the following is not a valid consumer group mapping attribute?
CLIENT_OS_USER
MODULE_NAME
CLIENT_PROGRAM
MODULE_ACTION
SERVICE_MODULE_ACTION
Which of the following methods of CPU allocation can be defined for a single-level resource plan?
RATIO
EMPHASIS
BASIC
A, B, and C
Both A and B
What is the effect of the ...
Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.