Oracle
1Z0-063 · Question #83
View the Exhibit showing steps to create a database resource manager plan. SQL>execute dbms_resource_manager. create_pendingarea(); PL/SQL procedure successfully completed. SQL>execd…
The correct answer is B. The procedure must be executed before creating any plan directive. See the full explanation below for the reasoning.
Question
View the Exhibit showing steps to create a database resource manager plan. SQL>execute dbms_resource_manager. create_pendingarea(); PL/SQL procedure successfully completed. SQL>execd bms_resource_manager, create_consumergroup (consumer_group=>'OLTP,,comment=>,onlineuser') PL/SQL procedure successfully completed. SQL>execdbras_resource_raanager. create_plan(plan=>'PRIU3ER3',comment=>'dssprio'); SQL>exec Dbms_resource_manager. create_plan_directive(plan=>'PRIU3ER3', group_or_subplan=>' OLTP',comraent=>'onlinegrp'CPU_Pl=>60); PL/SQL procedure successfully completed. After execting the steps in the exhibit you execute this procedure, which results in an error: SQL> EXECUTEdbms_resource_manager. validate_pending_area (); What is the reason for the error?
Options
- AThe pending area is automatically submitted when creating plan directives.
- BThe procedure must be executed before creating any plan directive.
- CThe sys_group group is not included in the resource plan.
- DThe other_groups group is not included in the resource plan.
- EPending areas can not be validated until submitted.
How the community answered
(28 responses)- B86% (24)
- C4% (1)
- D7% (2)
- E4% (1)
Community Discussion
No community discussion yet for this question.