试题详情
单项选择题 You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline 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：  ORA/x7f01031： insufficient privileges  ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115  ORA/x7f06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA/x7f06512： 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

  • E

  • 关注下方微信公众号，在线模考后查看

热门试题