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

Oracle认证考试

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

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
答案解析:
进入题库查看解析

微信扫一扫手机做题