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.