单项选择题
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.
相关考题
-
单项选择题
TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement：SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’；Whatwillbetheoutcomeofthisstatement？（）
A. The statement will deactivate DAY_PLAN.
B. The statement will activate DAY_PLAN as the top plan.
C. The statement will activate MANAGERS_PLAN as the top plan.
D. The statement will return an error because MANAGERS_PLAN is not the top plan. -
单项选择题
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？（）
A. The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.
B. The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
C. The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
D. The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes. -
单项选择题
Click the Exhibit（s） button to view the DEPARTMENTS plan. After analyzing the Exhibit， what conclusion will you draw？（）
A. The CPU cannot be assigned to the members of the SYS_GROUP group.
B. The members of the OTHER_GROUPS group will always be assigned 100 percent CPU.
C. The members of the OTHER_GROUPS group will never be assigned 100 percent CPU.
D. The members of the OTHER_GROUPS group will be assigned 100 percent CPU if the CPU is not assigned to the members of the SYS_GROUP group and the PAYROLL， SALES， and MARKETING groups.
