You issue the following code: EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP (’SCOTT’ ’GRP1’, TRUE); What will be the result of executing the above code?()
- A The switch privilege will be granted to the user, Scott, for changing the consumer group to GRP1.
- B The switch privilege will be granted to the user, Scott, for changing the consumer group from GRP1 to any other group.
- C The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
- DThe code will execute successfully but no privilege will be granted to the user, Scott.