Oracle Database 12c: Advanced Administration — Question 36

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_subplan=>'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?

Answer options

• A. The pending area is automatically submitted when creating plan directives.
• B. The procedure must be executed before creating any plan directive.
• C. The sys_group group is not included in the resource plan.
• D. The other_groups group is not included in the resource plan.
• E. Pending areas can not be validated until submitted.

Correct answer: B

Explanation

The correct answer is B because the procedure dbms_resource_manager.validate_pending_area must be executed prior to the creation of any plan directives. Other options are incorrect as they either state facts that do not apply to the given scenario or refer to group inclusion which is not relevant to the error encountered.