多选题Which of these represent the main components of Database Resource Manager？（）AResource consumer groupsBResource plansCResource-plan groupsDResource-plan directivesEAll of the above

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

相似考题

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.Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings？（）  A、 CREATE_MAPPING_PRIORITYB、 SET_MAPPING_PRIORITYC、 SET_MAPPING_ORDERD、 PRIORITIZE_MAPPING_ORDERE、 This functionality is not available through the DBMS_RESOURCE_MANAGER package.

3.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$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP

4.Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?()A. Maximum Undo per consumer groupB. Maximum Idle timeC. Parallel server limitD. CPUE. Exadata I/OF. Local file system I/O

更多“多选题Which of these represent the main components of Database Resource Manager？（）AResource consumer groupsBResource plansCResource-plan groupsDResource-plan directivesEAll of the above”相关问题

  • 第1题：

    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

    正确答案:A

  • 第2题：

    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

  • 第3题：

    Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）

    • A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
    • B、In a PDB plan, subplans may be used with up to eight consumer groups.
    • C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
    • D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
    • E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

    正确答案:A,B,C,D,E

  • 第4题：

    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.

    正确答案:A

  • 第5题：

    Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）

    • A、Maximum Undo per consumer group
    • B、Maximum Idle time
    • C、Parallel server limit
    • D、CPU
    • E、Exadata I/O
    • F、Local file system I/O

    正确答案:C,D,F

  • 第6题：

    多选题
    Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）
    A

    SWITCH_TIME

    B

    SWITCH_GROUP

    C

    MAX_SESS_POOL

    D

    SWITCH_ESTIMATE


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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings？（）
    A

     CREATE_MAPPING_PRIORITY

    B

     SET_MAPPING_PRIORITY

    C

     SET_MAPPING_ORDER

    D

     PRIORITIZE_MAPPING_ORDER

    E

     This functionality is not available through the DBMS_RESOURCE_MANAGER package.


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

  • 第9题：

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


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

  • 第10题：

    多选题
    You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
    A

    Application Server Control

    B

    Oracle Management Service

    C

    Oracle Enterprise Manager Repository

    D

    Oracle Enterprise Manager Database Control


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

  • 第11题：

    多选题
    In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager.  For which three resources can you enable usage restrictions by using Resource Manager？（）
    A

    CPU usage

    B

    degree of parallelism

    C

    number of open cursors

    D

    number of sorts performed

    E

    idle time for blocking sessions

    F

    number of disk I/O operations performed

    G

    number of memory I/O operations performed


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

  • 第12题：

    单选题
    You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）
    A

     The switch privilege is granted to the PROG_ROLE role.

    B

     The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.

    C

     The users cannot grant the switch privilege to other users.

    D

     The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）

    • A、 CPU usage
    • B、 degree of parallelism
    • C、 number of open cursors
    • D、 number of sorts performed
    • E、 idle time for blocking sessions
    • F、 number of disk I/O operations performed
    • G、 number of memory I/O operations performed

    正确答案:A,B,E

  • 第16题：

    You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）  

    • A、 The switch privilege is granted to the PROG_ROLE role.
    • B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
    • C、 The users cannot grant the switch privilege to other users.
    • D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

    正确答案:D

  • 第17题：

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


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

  • 第18题：

    多选题
    Which of the following WebSphere Commerce V5.5 components are required to publish a basic store that can process orders？（）
    A

    Catalog Manager

    B

    WebSphere Application Server

    C

    WebSphere Edge Server

    D

    A Database Server

    E

    Payment Manager


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

  • 第19题：

    多选题
    You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）
    A

    CPU usage

    B

    degree of parallelism

    C

    number of open cursors

    D

    number of sorts performed

    E

    idle time for blocking sessions

    F

    number of disk I/O operations performed

    G

    number of memory I/O operations performed


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    多选题
    Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）
    A

    Maximum Undo per consumer group

    B

    Maximum Idle time

    C

    Parallel server limit

    D

    CPU

    E

    Exadata I/O

    F

    Local file system I/O


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）
    A

    If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.

    B

    In a PDB plan, subplans may be used with up to eight consumer groups.

    C

    If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.

    D

    If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

    E

    If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.


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

相关内容