Oracle
1Z0-043 · Question #49
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'…
The correct answer is E. grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the. See the full explanation below for the reasoning.
Question
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 errors out 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?
Options
- Agrant SYSDBA to the user
- Bgrant SYSOPER to the user
- Cgrant the RESOURCE role to the user
- Duse the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
- Egrant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the
How the community answered
(21 responses)- B5% (1)
- C10% (2)
- D5% (1)
- E81% (17)
Community Discussion
No community discussion yet for this question.