违法和不良信息举报 联系客服
免费注册 登录

You have created a resource plan， DB_PLAN， using DBMS_RESOUR

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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Before a project schedule can be created,the schedule maker should have a（）,an effort estimate for each task,and a resource list with availability for each resource

A.work breakdown structure

B.baseline

C.software requirements specification

D.plan


正确答案：A
解析：制定项目进度计划之前，制定计划者需要（）、各任务的工作量估计以及可能得到的资源列表A、分解结构B、基线C、软件需求描述D、计划

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

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 creation

B. The procedure must be executed before creating the resources plan directive

C. The SYS_GROUP resource consumer group is not included in the resource plan directive

D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive


参考答案：D

第4题：

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

第5题：

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

第6题：

Before a project schedule can be created,the schedule maker should have a （ ） ,an effort estimate for each task,and a resource list with availability for each resource.

A.work breakdown structure
B.baseline
C.software requirements specification
D.plan

答案：A
解析：
翻译：在项目进度计划制定前，制定者应该有一份工作分解结构，一份针对每个任务的工作量估算，以及可用资源列表。A．工作分解结构 B．基线 C．软件需求说明书 D．计划

第7题：

The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）  

  • A、 The statement will deactivate DAY_PLAN.
  • B、 The statement will activate DAY_PLAN as the top plan.
  • C、 The statement will activate MANAGERS_PLAN as the top plan.
  • D、 The statement will return an error because MANAGERS_PLAN is not the top plan.

正确答案:C

第8题：

Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）

A.assignuserstoconsumergroups

B.settheresourceplanfortheinstance

C.configureasimpleresourceplanandspecifyplandirectives

D.configureacomplexresourceplanandspecifyplandirectives


参考答案：B

第9题：

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

第10题：

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

更多相关问题
相关内容