O

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

264 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

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?

Choose the correct option from the given list.
01 / 264

0 Discussions

Trending Exams