1Z0-067 · Question #47
View the Exhibit showing steps to create a database resource manager plan. SQL>executedbms_resource_manager.create_pendingarea(); PL/SQLproceduresuccessfully completed…
The correct answer is D. The other_groups group is not included in the resource plan. See the full explanation below for the reasoning.
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.
How the community answered
(23 responses)- A13% (3)
- B4% (1)
- C4% (1)
- D78% (18)
Community Discussion
No community discussion yet for this question.