OCP CBT Question 681

Please solve the following question.

You have a large database with mixed workloads and occasionally experience performance degradation due to a few long-running, CPU-intensive batch jobs. You want to create a resource plan where: 1. OLTP users get 60% of CPU at level 1. 2. Batch jobs get 30% of CPU at level 1. 3. Reporting users get 10% of CPU at level 1. 4. If OLTP users are not utilizing their full CPU allocation, batch jobs should be able to use more than their 30% up to 40% of the CPU at level 2. Which set of directives correctly implements these requirements for 'MY_PLAN'?

Assume MY_PLAN, OLTP_GROUP, BATCH_GROUP, and REPORT_GROUP are already created in a pending area.

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'OLTP_GROUP', MGMT_PERCENT => 60, MGMT_LEVEL => 1);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP', MGMT_PERCENT => 30, MGMT_LEVEL => 1, MGMT_PERCENT => 40, MGMT_LEVEL => 2);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'REPORT_GROUP', MGMT_PERCENT => 10, MGMT_LEVEL => 1);

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'OLTP_GROUP', MGMT_PERCENT => 60);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP', MGMT_PERCENT => 30, MGMT_LEVEL => 1, MGMT_PERCENT => 40, MGMT_LEVEL => 2);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'REPORT_GROUP', MGMT_PERCENT => 10);

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'OLTP_GROUP', MGMT_PERCENT => 60, MGMT_LEVEL => 1);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP', MGMT_PERCENT => 30, MGMT_LEVEL => 1);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP', MGMT_PERCENT => 40, MGMT_LEVEL => 2);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'REPORT_GROUP', MGMT_PERCENT => 10, MGMT_LEVEL => 1);

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'OLTP_GROUP', MGMT_PERCENT => 60, LEVEL => 1);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP', MGMT_PERCENT => 30, LEVEL => 1, MGMT_PERCENT => 40, LEVEL => 2);
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'REPORT_GROUP', MGMT_PERCENT => 10, LEVEL => 1);