OCP CBT Question 685

Please solve the following question.

You have implemented a resource plan. You notice that some sessions in the 'BATCH_GROUP' are spawning many parallel queries and consuming excessive resources, leading to performance issues for other groups. You want to limit the maximum degree of parallelism for any query in the 'BATCH_GROUP' to 4 and also queue any parallel statement that exceeds this limit for a maximum of 300 seconds. Which directive parameters should you use?

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

DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP',
  PARALLEL_DEGREE_LIMIT_P1 => 4, PARALLEL_QUEUE_TIMEOUT => 300);

DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP',
  MAX_PARALLEL_DEGREE => 4, PARALLEL_STATEMENT_TIMEOUT => 300);

DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP',
  PARALLEL_TARGET_PERCENT => 4, PARALLEL_QUEUE_WAIT => 300);

DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(
  PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'BATCH_GROUP',
  MAX_PARALLEL_PROCESSES => 4, QUEUE_TIMEOUT => 300);