Oracle
1Z0-067 · Question #47
1Z0-067 Question #47: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #47. The question stem and answer options stay visible for context.
Question
View the Exhibit showing steps to create a database resource manager plan. SQL>executedbms_resource_manager.create_pendingarea(); PL/SQLproceduresuccessfully completed. 3QL>execdbms_resource_manager,create_consumergroup (consumer_group=>'OLTP,,comment=>,onlineuser') PL/SQLproceduresuccessfullycompleted. SQL>execdbras_resource_raanager.create_plan(plan=>'PRIU3ER3',comment=>' dssprio'); SQL>exec Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_s ubplan=>'OLTP',comraent=>'onlinegrp'CPU_Pl=>60); PL/3QLproceduresuccessfullycompleted. 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-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 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.