单项选择题
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.
单项选择题 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？（）
单项选择题 TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement：SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’；Whatwillbetheoutcomeofthisstatement？（）
单项选择题 You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement： SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE （PLAN => ’SALES_PLAN’， GROUP_OR_SUBPLAN => ’MANAGERS’， CPU_P1 => 100， CPU_P2 =>0， SWITCH_GROUP => ’CLERKS’， SWITCH_TIME_IN_CALL => 600）； A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）