單項選擇題

You have created a resource plan， DAY. You execute the following code：       
SQL> BEGIN  
     DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE  
（ PLAN => ’DAY’，       
COMMENT => ’DEPARTMENTS PLAN’，  
GROUP_OR_SUBPLAN => ’DEPARTMENTS’，       
CPU_P1=0）；       
END；  
Then， you issue the following code：       
SQL> BEGIN  

DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE       
（ PLAN => ’DAY’，       
COMMENT => ’DEPARTMENTS PLAN’，      
 GROUP_OR_SUBPLAN => ’DEVELOPERS’，       
CPU_P2=100）；       
END；  
What will be the impact of executing the above code？（）  

A. The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.
B. The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.
C. The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.
D. The second code will not execute because one resource plan cannot be used by more than one subplan.

題目列表

你可能感興趣的試題

多項選擇題

You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

A. The batch operation started by the user， SCOTT， terminates with an error.
B. The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
C. The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
D. The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
E. The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.
微信掃碼免費搜題