多选题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？（）ASWITCH_TIMEBSWITCH_GROUPCMAX

第1题：

第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 notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur？（）  

• A、 The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.
• B、 The job affinity is to a service and one node in that service is unavailable.
• C、 The job affinity is to an instance and that instance is unavailable.
• D、 There is no service affinity.
• E、 None of the above.

第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题：

Which of the following objects can be directly referenced by a window object？（）

• A、 Schedule object
• B、 Program object
• C、 Job object
• D、 Resource plan
• E、 Resource consumer group

第10题：

You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）  

• A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.
• B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
• C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
• D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.