多选题You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives：  Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4.   Consumer group MARKETwith CPU_P1as 20.   Consumer group DEVwi

第1题：

You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives：  Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4.   Consumer group MARKETwith CPU_P1as 20.   Consumer group DEVwith CPU_P1as 20.   Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100.  Which two statements are correct in this scenario？（）

• A、 The maximum degree of parallelism for the members of the consumer groups is 4.
• B、 The CPU allocation will always be equal for the consumer groups MARKET and DEV.
• C、 The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.
• D、 The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.
• E、 The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

第2题：

Every resource plan must contain an allocation to which consumer group？（）

• A、 LOW_GROUP
• B、 SYS_GROUP
• C、 DEFAULT_GROUP
• D、 BASE_GROUP
• E、 OTHER_GROUPS

第3题：

第4题：

You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（）  

• A、 45.5
• B、 65
• C、 70
• D、 100

第5题：

You have created a resource plan， PROD_DB_PLAN， that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan： Consumer group HIGH_CG with CPU_P1 as 10.  Consumer group MEDIUM_CG with CPU_P1 as 5.  Consumer group LOW_CG with CPU_P1 as 2.  Consumer group OTHER_GROUPS with CPU_P1 as 1.  Which statement is correct in this scenario？（）

• A、 The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.
• B、 The members of the HIGH_CG consumer group would get 10% of the CPU.
• C、 The plan PROD_DB_PLAN can have subplans.
• D、 The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.

第6题：

You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives：  Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20.  Consumer group DEV with CPU_P1 as 20.  Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100.  Which two statements are correct in this scenario？ （）

• A、The maximum degree of parallelism for the members of the consumer groups is 4.
• B、The CPU allocation will always be equal for the consumer groups MARKET and DEV.
• C、The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.
• D、The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.
• E、The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

第7题：

You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（） 

• A、 CPU_MTH
• B、 NEW_CPU_MTH
• C、 CPU_P1
• D、 CPU_P2

第8题：

第9题：

You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan？（）

• A、assign users to consumer groups
• B、set the resource plan for the instance
• C、configure a simple resource plan and specify plan directives
• D、configure a complex resource plan and specify plan directives

第10题：

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.