nerdexam
Oracle

1Z0-043 · Question #112

You execute the following command to create two consumer groups, FIN_GROUP1 and PAY_GROUP1 for a plan, PROD_PLAN: BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN( SIMPLE_PLAN => 'prod_plan'…

The correct answer is A. SYS_GROUP gets 100% CPU resources at level 1. C. FIN_GROUP1 gets 80% CPU resources at level 2. E. PAY_GROUP1 gets 20% CPU resources at level 2. See the full explanation below for the reasoning.

Question

You execute the following command to create two consumer groups, FIN_GROUP1 and PAY_GROUP1 for a plan, PROD_PLAN:

BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN( SIMPLE_PLAN => 'prod_plan', CONSUMER_GROUP1 => 'fin_group1', GROUP1_CPU => 80, CONSUMER_GROUP2 => 'pay_group1', GROUP2_CPU=>20); END; Which three statements are true? (Choose three)

Options

  • ASYS_GROUP gets 100% CPU resources at level 1.
  • BFIN_GROUP1 gets 80% CPU resources at level 1.
  • CFIN_GROUP1 gets 80% CPU resources at level 2.
  • DPAY_GROUP1 gets 20% CPU resources at level 1.
  • EPAY_GROUP1 gets 20% CPU resources at level 2.
  • FOTHER_GROUP gets 100% CPU resources at level 1.
  • GOTHER_GROUP gets 100% CPU resources at level 2.

How the community answered

(27 responses)
  • A
    78% (21)
  • B
    4% (1)
  • D
    11% (3)
  • F
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice