OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

11.9. Review Questions

1. Which system privileges allow you to administer the Database Resource Manager?

   1. DBA

   2. ADMINISTER_ANY_RESOURCE

   3. ADMINISTER_RESOURCE_MANAGER

   4. RESOURCE_MANAGER_ADMIN

   5. All of the above

2. When creating a plan directive, which of the following resource allocation methods are valid when the target of the directive is a sub-plan?

   1. Execution time limit

   2. Undo pool

   3. Automatic consumer group switching

   4. Canceling SQL and terminating sessions

   5. CPU method

3. Which of the following is not a valid consumer group mapping attribute?

   1. CLIENT_OS_USER

   2. MODULE_NAME

   3. CLIENT_PROGRAM

   4. MODULE_ACTION

   5. SERVICE_MODULE_ACTION

4. Which of the following methods of CPU allocation can be defined for a single-level resource plan?

   1. RATIO

   2. EMPHASIS

   3. BASIC

   4. A, B, and C

   5. Both A and B

5. What is the effect of the ...