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.
D. The code will execute successfully but no privilege will be granted to the user, Scott.