多选题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题：

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

第2题：

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.

第3题：

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

第4题：

You updated the resource plan directive for the resource consumer group， DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE  （PLAN => ’DSS_PLAN’，   GROUP_OR_SUBPLAN => ’DSS_USERS’，   NEW_CPU_P1 => 80，   NEW_SWITCH_GROUP => ’CANCEL_SQL’，   NEW_SWITCH_ESTIMATE => TRUE，   NEW_SWITCH_TIME => 600）； A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds？（）  

• A、 The session is killed before starting the operation.
• B、 The session generates an error before starting the operation.
• C、 The session switches to the CANCEL_SQL resource consumer group before starting the operation.
• D、 The session hangs before starting the operation.

第5题：

Which statement is true while creating subplans using Resource Manager？（）

• A、 The subplan must belong to the consumer group， SYS_GROUP.
• B、 The total CPU usage at any given level must be less than 100%.
• C、 The subplans can be used to restrict the degree of parallelism for a user.
• D、 You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.

第6题：

In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）

• A、The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
• B、The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
• C、The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
• D、If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.
• E、If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

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.

第16题：

Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）

• A、SWITCH_TIME
• B、SWITCH_GROUP
• C、MAX_SESS_POOL
• D、SWITCH_ESTIMATE

第17题：

You issue the following code：    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        （’SCOTT’ ’GRP1’， TRUE）；   What will be the result of executing the above code？（）  

• A、 The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.
• B、 The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.
• C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
• D、The code will execute successfully but no privilege will be granted to the user， Scott.

第18题：

You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1 for a plan， PROD_PLAN：  BEGIN  DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN =>’prod_plan’，  CONSUMER_GROUP1 => ’fin_group1’，  GROUP1_CPU => 80，  CONSUMER_GROUP2 => ’pay_group1’，  GROUP2_CPU => 20）；  END；  Which three statements are true？ （）

• A、 SYS_GROUP gets 100% CPU resources at level 1.
• B、 FIN_GROUP1 gets 80% CPU resources at level 1.
• C、 FIN_GROUP1 gets 80% CPU resources at level 2.
• D、 PAY_GROUP1 gets 20% CPU resources at level 1.
• E、 PAY_GROUP1 gets 20% CPU resources at level 2.
• F、 OTHER_GROUP gets 100% CPU resources at level 1.
• G、 OTHER_GROUP gets 100% CPU resources at level 2.

第19题：

第20题：

第21题：

第22题：

第23题：