Which three statements are true?

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)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *