日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

單項(xiàng)選擇題

The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）  

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.

題目列表

你可能感興趣的試題

單項(xiàng)選擇題

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.
微信掃碼免費(fèi)搜題