单选题Every resource plan must contain an allocation to which consumer group？（）ALOW_GROUPBSYS_GROUPCDEFAULT_GROUPDBASE_GROUPEOTHER_GROUPS

题目
单选题
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

相似考题

1.View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）A. The pending area is automatically submitted after the plan creationB. The procedure must be executed before creating the resources plan directiveC. The SYS_GROUP resource consumer group is not included in the resource plan directiveD. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

2. 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.

3. 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.

4. A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database.  Which of the following statements best describes the need for custom resource monitor？（）  A、 Multiple application servers must be in a single resource group.B、 Multiple application servers per resource group may be monitored.C、 Multiple resource groups must each contain a single application server.D、 Multiple application servers in a cluster cannot use process monitoring.

更多“单选题Every resource plan must contain an allocation to which consumer group？（）A  LOW_GROUPB  SYS_GROUPC  DEFAULT_GROUPD  BASE_GROUPE  OTHER_GROUPS”相关问题

  • 第1题：

    You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  

    • A、 V$SYSSTAT
    • B、 V$SESSSTAT
    • C、 V$RSRC_PLAN
    • D、 V$RSRC_CONSUMER_GROUP

    正确答案:D

  • 第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.

    正确答案:D

  • 第3题：

    Which of these represent the main components of Database Resource Manager？（）

    • A、 Resource consumer groups
    • B、 Resource plans
    • C、 Resource-plan groups
    • D、 Resource-plan directives
    • E、 All of the above

    正确答案:A,B,D

  • 第4题：

    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.

    正确答案:A

  • 第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.

    正确答案:D

  • 第6题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第7题：

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


    正确答案： A,D
    解析： 暂无解析

  • 第8题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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 plan PROD_DB_PLAN can have subplans.

    B

    The members of the HIGH_CG consumer group would get 10% of the CPU.

    C

    The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.

    D

    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.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）
    A

     A window must have been created with the WEEKEND_PLAN resource plan.

    B

     A program must have been created with the WEEKEND_PLAN resource plan.

    C

     A job class must have been created with the WEEKEND_PLAN resource plan.

    D

     A window group must have been created with the WEEKEND_PLAN resource plan.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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

    正确答案:E

  • 第14题：

    Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

    • A、 A window must have been created with the WEEKEND_PLAN resource plan.
    • B、 A program must have been created with the WEEKEND_PLAN resource plan.
    • C、 A job class must have been created with the WEEKEND_PLAN resource plan.
    • D、 A window group must have been created with the WEEKEND_PLAN resource plan.

    正确答案:C

  • 第15题：

    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

    正确答案:B

  • 第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

    正确答案:A,B,D

  • 第17题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第18题：

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


    正确答案： E,B
    解析： 暂无解析

  • 第19题：

    单选题
    You are using Resource Manager to manage system resources. While creating a new database user， you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this？（）
    A

    The Resource Manager plan does not affect the user.

    B

    There must be a plan directive in any of the plans of the group to control the resources.

    C

    The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.

    D

    The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.

    E

    The members of this group can change their group without the database administrator’s intervention.


    正确答案： E
    解析： 暂无解析

  • 第20题：

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


    正确答案： B,C
    解析： 暂无解析

  • 第21题：

    单选题
    A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database.  Which of the following statements best describes the need for custom resource monitor？（）
    A

     Multiple application servers must be in a single resource group.

    B

     Multiple application servers per resource group may be monitored.

    C

     Multiple resource groups must each contain a single application server.

    D

     Multiple application servers in a cluster cannot use process monitoring.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）
    A

     RATIO

    B

     EMPHASIS

    C

     ACTIVE_SESS_POOL_MTH

    D

     RESOURCE_DEGREE_LIMIT_ABSOLUTE


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）
    A

     V$SYSSTAT

    B

     V$SESSSTAT

    C

     V$RSRC_PLAN

    D

     V$RSRC_CONSUMER_GROUP


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

相关内容