单项选择题
A.The plan PROD_DB_PLAN can have subplans.
B.The members of the HIGH_CG consumer group would get 10% of the CPU.
C.The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.
D.The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.
单项选择题 You want to create a consumer group， GROUP1， and you execute the following command in the commandline interface： SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’） This command errors out displaying the following message： ERROR at line 1： ORA01031： insufficient privileges ORA06512： at "SYS.DBMS_RMIN"， line 115 ORA06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA06512： at line 1 What action would you take to overcome this error？（）
单项选择题 You want to create a consumer group， GROUP1， and you execute the following command in the commandline interface： SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’） This command errors out displaying the following message： ERROR at line 1： ORA29371： pending area is not active ORA06512： at "SYS.DBMS_RMIN"， line 115 ORA06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA06512： at line 1 What action would you take to overcome this error？（）
多项选择题 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？（）