单项选择题
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. -
单项选择题
YouareusingResourceManagertomanagesystemresources.Whilecreatinganewdatabaseuser，youobservethattheuserisamemberofDEFAULT_CONSUMER_GROUPbydefault.Whatwouldbetheimplicationsofthis？（）
A.The Resource Manager plan does not affect the user.
B.There must be a plan directive in any of the plans of the group to control the resources.
C.The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.
D.The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.
E.The members of this group can change their group without the database administrator’s intervention.
