Oracle
1Z0-063 · Question #83
1Z0-063 Question #83: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-063 to reveal the answer and full explanation for question #83. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-063 to see the answer
You've previewed enough free 1Z0-063 questions. Unlock 1Z0-063 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.