多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’, COMMENT => ’New Group’);  This command errorsout displaying the following message:  ERROR at line 1:  ORA-01031: insufficient privileges  ORA-06512: at "SYS.DBMS_RMIN", line 115  ORA-06512: at SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: 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 use
  • E、 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
正确答案:E
答案解析:
进入题库查看解析

微信扫一扫手机做题