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)
A.
SYS_GROUP gets 100% CPU resources at level 1.
B.
FIN_GROUP1 gets 80% CPU resources at level 1.
C.
FIN_GROUP1 gets 80% CPU resources at level 2.
D.
PAY_GROUP1 gets 20% CPU resources at level 1.
E.
PAY_GROUP1 gets 20% CPU resources at level 2.
F.
OTHER_GROUP gets 100% CPU resources at level 1.
G.
OTHER_GROUP gets 100% CPU resources at level 2.