Question 83:
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.