The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()
第1题:
A.RATIO
B.EMPHASIS
C.ACTIVE_SESS_POOL_MTH
D.RESOURCE_DEGREE_LIMIT_ABSOLUTE
第2题:
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.
第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
第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?()
第5题:
What is a key new feature in Tivoli Storage Manager Version 6 that allows for a larger sizeddatabase?()
第6题:
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
第7题:
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()
第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
第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?()
第10题:
Which of these represent the main components of Database Resource Manager?()