Friday, 25 September 2009

Performance Tuning - Question 078.

Which of the following Resource Manager rules must be validated with the DBMS_RESOURCE_MANAGER.validate_pending_area procedure? (Choose three.)

A. The plan must have a directive for OTHER_GROUPS.

B . Each subplan must reference the top-level plan's consumer group.

C. Referenced subplans and/or consumer groups must exist.

D. No subplan loops.

E . The plan must have a directive for SYSTEM_GROUP.

Explanation:

Answer A, C and D: The validate_pending_area procedure checks the entries in the resource plan against the Resource Manager rules. The plan must specify a directive for OTHER_GROUPS. No subplan loops are allowed; that is, no subplan can have a directive that includes a higher-level plan as a subplan. All referenced subplans and consumer groups are verified.

No comments:

Post a Comment