单选题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？（）ARATIOBEMPHASISCACTIVE_SESS_POOL_MTHDRESOURCE_DEGREE_LIMIT_ABSOLUTE

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

相似考题

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.Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives

3.For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning priorities to jobs to manage access to system resourcesE. creating alerts to perform notification when tablespaces are low on available space resources

4.For which two situations would you use functionality provided by the Resource Manager?()A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning priorities to jobs to manage access to system resourcesE. creating alerts to perform notification when tablespaces are low on available space resources

更多“You are creating the simple resource plan using the DBMS_RES”相关问题

  • 第1题：

    Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：

    SQL>BEGIN

    DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE

    （PLAN=>’DAY’，

    COMMENT=>’DEPARTMENTSPLAN’，

    GROUP_OR_SUBPLAN=>’DEPARTMENTS’，

    CPU_P1=0）；

    END；

    Then，youissuethefollowingcode：

    SQL>BEGIN

    DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE

    （PLAN=>’DAY’，

    COMMENT=>’DEPARTMENTSPLAN’，

    GROUP_OR_SUBPLAN=>’DEVELOPERS’，

    CPU_P2=100）；

    END；

    Whatwillbetheimpactofexecutingtheabovecode？（）


    参考答案：B

  • 第2题：

    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

  • 第3题：

    For which two situations would you use functionality provided by the Resource Manager? （）(Choose two.)

    • A、setting idle timeout limits on resource plans
    • B、saving storage space by using compressed backup sets
    • C、creating jobs that will run automatically at a scheduled time
    • D、assigning priorities to jobs to manage access to system resources
    • E、creating alerts to perform notification when tablespaces are low on available space resources

    正确答案:A,D

  • 第4题：

    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

  • 第5题：

    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

    正确答案:A,B,E

  • 第6题：

    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

  • 第7题：

    单选题
    You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.You have received instructions from the CIO to support Autodiscover from the Internet by creating a resource record in DNS.What should you do？（）
    A

    You should consider creating a Host （A） resource record.

    B

    You should consider creating a Text （TXT） resource record.

    C

    You should consider creating a Pointer （PTR） resource record.

    D

    You should consider creating a Mail exchange （MX） resource record.


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

  • 第8题：

    单选题
    You have created a resource plan， DAY. You execute the following code：        SQL> BEGIN        DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE   （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，   GROUP_OR_SUBPLAN => ’DEPARTMENTS’，        CPU_P1=0）；        END；   Then， you issue the following code：        SQL> BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE        （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，        GROUP_OR_SUBPLAN => ’DEVELOPERS’，        CPU_P2=100）；        END；   What will be the impact of executing the above code？（）
    A

     The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.

    B

     The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.

    C

     The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.

    D

     The second code will not execute because one resource plan cannot be used by more than one subplan.


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

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


    正确答案： 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 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


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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

    正确答案:B

  • 第16题：

    Using Oracle Scheduler you have scheduled two jobs， JOB_A and 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 windows group must have been created with the WEEKEND_PLAN resource plan.

    正确答案:A

  • 第17题：

    For which two situations would you use functionality provided by the Resource Manager？（）

    • A、 setting idle timeout limits on resource plans
    • B、 saving storage space by using compressed backup sets
    • C、 creating jobs that will run automatically at a scheduled time
    • D、 assigning priorities to jobs to manage access to system resources
    • E、 creating alerts to perform notification when tablespaces are low on available space resources

    正确答案:A,D

  • 第18题：

    You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.You have received instructions from the CIO to support Autodiscover from the Internet by creating a resource record in DNS.What should you do？（）

    • A、You should consider creating a Host （A） resource record.
    • B、You should consider creating a Text （TXT） resource record.
    • C、You should consider creating a Pointer （PTR） resource record.
    • D、You should consider creating a Mail exchange （MX） resource record.

    正确答案:A

  • 第19题：

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


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

  • 第20题：

    单选题
    Using Oracle Scheduler you have scheduled two jobs， JOB_A and 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 windows group must have been created with the WEEKEND_PLAN resource plan.


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

  • 第21题：

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


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

  • 第22题：

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

  • 第23题：

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


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

相关内容