The Database Resource Manager is

题目

The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()

  • A、to prevent the creation of an excessive number of scheduler job classes
  • B、to allow the Automated Maintenance Tasks to use system resources without any restriction
  • C、to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
  • D、to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan?()

A.RATIO

B.EMPHASIS

C.ACTIVE_SESS_POOL_MTH

D.RESOURCE_DEGREE_LIMIT_ABSOLUTE


参考答案:B

第2题:

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

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

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

第5题:

What is a key new feature in Tivoli Storage Manager Version 6 that allows for a larger sizeddatabase?()

  • A、 DB2 is the underlying database manager 
  • B、 Data is compressed without any change to the database 
  • C、 SSD drives are now required allowing for faster database access 
  • D、 Deduplication within the database shrinks the size of the current database

正确答案:A

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

The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()  

  • A、 to prevent the creation of an excessive number of scheduler job classes
  • B、 to allow the Automated Maintenance Tasks to use system resources without any restriction
  • C、 to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
  • D、 to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

正确答案:D

第8题:

Youwanttocreateaconsumergroup,GROUP1,andyouexecutethefollowingcommandinthecommandlineinterface:SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP=>’group1’,COMMENT=>’NewGroup’)Thiscommanderrorsoutdisplayingthefollowingmessage:ERRORatline1:ORA01031:insufficientprivilegesORA06512:at"SYS.DBMS_RMIN",line115ORA06512:atSYS.DBMS_RESOURCE_MANAGER",line108ORA06512:atline1Whatactionwouldyoutaketoovercomethiserror?()

A.grantSYSDBAtotheuser

B.grantSYSOPERtotheuser

C.granttheRESOURCEroletotheuser

D.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuser

E.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage


参考答案:E

第9题:

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

第10题:

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

更多相关问题