欢迎来到牛牛题库网 牛牛题库官网
logo
全部科目 > Oracle认证考试 > 1z0-043

单项选择题

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

点击查看答案&解析

相关考题

多项选择题

These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC v$FLASHBACK_DATABASE_STAT 
Name                    Null?              Type 
------------- -------- -------------- 
BEGIN_TIME                               DATE 
END_TIME                                 DATE 
FLASHBACK_DATA                        NUMBER 
DB_DATA                                  NUMBER 
REDO_DATA                               NUMBER 
ESTIMATED_FLASHBACK_SIZE             NUMBER 
Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()

A. BEGIN_TIME is the time at which Flashback logging is enabled.
B. END_TIME is the time at which the query is executed on the view.
C. REDO_DATA is the number of bytes of redo data written during the interval.
D. This view contains information about flashback data pertaining to the last 24 hours.
E. FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题