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

11.10. Answers to Review Questions

1. C. While the DBA role will grant the ADMINISTER_RESOURCE_MANAGER privilege, DBA is not a valid system privilege name.

2. E. A plan directive can only allocate CPU resources to a sub-plan. A, B, C, and D are all valid allocation methods, but they can only be defined for a resource consumer group, not for a sub-plan.

3. D. MODULE_ACTION is not a valid attribute by itself. The DBMS_APPLICATION_INFO package allows applications to define an application name and, secondarily, the action that they are currently performing. In general, the action without a corresponding name isn't useful. Therefore, MODULE_NAME and MODULE_NAME_ACTION are both useful and valid mapping attributes, but not MODULE_ACTION.

4. E. A single-level resource ...