ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

83 / 155

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.