97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

單項選擇題

You execute the following block of code：  
SQL>BEGIN  
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN  
（ SIMPLE_PLAN => ’DEPARTMENTS’，  
CONSUMER_GROUP1 => ’PAYROLLL’，  
GROUP1_CPU => 50，  
CONSUMER_GROUP2 => ’SALES’，  
GROUP2_CPU => 25，  
CONSUMER_GROUP3 => ’MARKETING’，  
GROUP3_CPU => 25）；  
END；  
SQL>/  
What is a prerequisite for using the simple resource plan created by executing the above code？（）

A. You must assign users to consumer groups.
B. You must grant the switch privilege to the users.
C. You must create a resource plan directive.
D. You must specify the complex resource plan.

題目列表

你可能感興趣的試題

單項選擇題

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.
微信掃碼免費搜題