欢迎来到易学考试网 易学考试官网
全部科目 > Oracle认证考试 > 1z0-043

单项选择题

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.

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题