单项选择题

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？（）

A.grant SYSDBA to the user
B.grant SYSOPER to the user
C.grant the RESOURCE role to the user
D.use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the user
E.grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

<上一题目录下一题>

热门试题

单项选择题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？（）

A.create the Pending Area before creating the consumer group
B.activate the Pending Area before creating the consumer group
C.increase the size of the large pool to accommodate the Pending Area
D.increase the size of the shared pool to accommodate the Pending Area
E.increase the size of the database buffer cache to accommodate the Pending Area

多项选择题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？（）

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.