OCP-1Z0-053-200题-17题-99

QUESTION 17

View the Exhibit and examine the steps that you executed to create a database resource plan.

Subsequently, you execute the following procedure which results in an error:

SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );

What could be the reason?

A. The pending area is automatically submitted after the plan creation

B. The procedure must be executed before creating theresources plan directive

C. The SYS_GROUP resource consumer group is not includedin the resource plan directive

D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

Answer: D

同99题:http://blog.csdn.net/rlhua/article/details/18795859


Explanation/Reference:

Section: Database Architecture & Resource Management, RAC, ASM

D is correct

Exhibit Reference:1Z0-033, 9i Performance Tuning, Question 146 of 164- Exact Question/Answer

SYBEX Oracle 1Z0-053 Study Guide, Chapter 11: Managing Database Resources

The validation process verifies that any changes inthe pending area will not result in a violation of any of the rules, such as the following:

There must be a plan directive for the OTHER_GROUPS group to allocate resources for sessions not identified in the active plan.

Oracle Press 1Z0-053 Exam Guide, Chapter 12: Disk Space and Resource Management

Remember that your plan must include OTHER_GROUPS so that users other than those in the consumer groups assigned to the [PLAN NAME] plan will have some resources available when the plan is activated.

Therefore, create one more plan directives for the [PLAN NAME] plan that includes OTHER_GROUPS.

原文地址:https://www.cnblogs.com/hzcya1995/p/13316163.html