單項(xiàng)選擇題

You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code：
SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP
（’SCOTT’， ’GRP1’， FALSE）；
How will you grant the switch privilege to the user， Scott？（）

A. by using the DBMS_SESSION package
B. by granting the DBA role
C. by using the DBMS_RESOURCE_MANAGER package
D. by using the DBMS_RESOURCE_MANAGER_PRIVS package

在線練習(xí)

你可能感興趣的試題

單項(xiàng)選擇題

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.

單項(xiàng)選擇題

You updated the resource plan directive for the resource consumer group， DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement：
SQL>EXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE （PLAN => ’DSS_PLAN’，
GROUP_OR_SUBPLAN => ’DSS_USERS’，
NEW_CPU_P1 => 80，
NEW_SWITCH_GROUP => ’CANCEL_SQL’，
NEW_SWITCH_ESTIMATE => TRUE，
NEW_SWITCH_TIME => 600）；
A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds？（）

A. The session is killed before starting the operation.
B. The session generates an error before starting the operation.
C. The session switches to the CANCEL_SQL resource consumer group before starting the operation.
D. The session hangs before starting the operation.

You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code： SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP （’SCOTT’， ’GRP1’， FALSE）； How will you grant the switch privilege to the user， Scott？（）

你可能感興趣的試題

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？（）

You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code：
SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP
（’SCOTT’， ’GRP1’， FALSE）；
How will you grant the switch privilege to the user， Scott？（）

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？（）