多选题Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated?()ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE

多选题
Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated?()
A

SWITCH_TIME

B

SWITCH_GROUP

C

MAX_SESS_POOL

D

SWITCH_ESTIMATE


参考解析

解析: 暂无解析

相关考题:

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

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 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.

The ip pim autorp listener command is used to do which of these?()A、enable a Cisco router to "passively" listen to Auto-RP packets without the router actively sending or forwarding any of the packetsB、allow Auto-RP packets in groups 224.0.1.39 and 224.0.1.40 to be flooded in dense mode out interfaces configured with the ip pim sparse-mode commandC、enable the use of Auto-RP on a routerD、configure the router as an Auto-RP mapping agent

Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()A、Bind Variable PeekingB、SQL Plan BaselinesC、Adaptive Cursor SharingD、Bind variable used in a SQL statementE、Literals in a SQL statement

Which three parameters are configured in the IKE policy?() (Choose three.)A、modeB、preshared keyC、external interfaceD、security proposalsE、dead peer detection settings

Which two statements about the Cisco AutoSecure feature are true?()A、All passwords entered during the AutoSecure configuration must be a minimum of 8 characters in length.B、Cisco123 would be a valid password for both the enable password and the enable secret commands.C、The auto secure command can be used to secure the router login as well as the NTP and SSH protocols.D、For an interactive full session of AutoSecure, the auto secure login command should be used.E、If the SSH server was configured, the 1024 bit RSA keys are generated after the auto secure commandis enabled.

Which of these represent the main components of Database Resource Manager?()A、 Resource consumer groupsB、 Resource plansC、 Resource-plan groupsD、 Resource-plan directivesE、 All of the above

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、 RATIOB、 EMPHASISC、 ACTIVE_SESS_POOL_MTHD、 RESOURCE_DEGREE_LIMIT_ABSOLUTE

You want to configure WebLogic so that Managed Servers are restarted when they are in a  FAILED state. Which three steps are necessary to accomplish this?()A、Configure Node Manager on the machines where WebLogic Managed Servers need to be  started/restarted.B、Enable "Auto Restart" in the Node Manager Configuration.C、Enable "Auto Kill if Failed" in the Node Manager Configuration.D、Enable "Auto Kill if Failed" for the Managed Server in question.E、Enable "Auto Restart" for the Managed Server in question.

Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated?()A、SWITCH_TIMEB、SWITCH_GROUPC、MAX_SESS_POOLD、SWITCH_ESTIMATE

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.

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.

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 usageB、degree of parallelismC、number of open cursorsD、number of sorts performedE、idle time for blocking sessionsF、number of disk I/O operations performedG、number of memory I/O operations performed

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

单选题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 RATIOB EMPHASISC ACTIVE_SESS_POOL_MTHD RESOURCE_DEGREE_LIMIT_ABSOLUTE

多选题Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()ABind Variable PeekingBSQL Plan BaselinesCAdaptive Cursor SharingDBind variable used in a SQL statementELiterals in a SQL statement

多选题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?()ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE

多选题Which two statements about the Cisco AutoSecure feature are true?()AAll passwords entered during the AutoSecure configuration must be a minimum of 8 characters in length.BCisco123 would be a valid password for both the enable password and the enable secret commands.CThe auto secure command can be used to secure the router login as well as the NTP and SSH protocols.DFor an interactive full session of AutoSecure, the auto secure login command should be used.EIf the SSH server was configured, the 1024 bit RSA keys are generated after the auto secure commandis enabled.

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

多选题Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?()AIf 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.BIn a PDB plan, subplans may be used with up to eight consumer groups.CIf a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.DIf no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.EIf 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.

单选题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 groupsB set the resource plan for the instanceC configure a simple resource plan and specify plan directivesD configure a complex resource plan and specify plan directives

多选题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? ()ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed

多选题Which three parameters are configured in the IKE policy? ()(Choose three.)AmodeBpreshared keyCexternal interfaceDsecurity proposalsEdead peer detection settings

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

单选题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?()Aassign users to consumer groupsBset the resource plan for the instanceCconfigure a simple resource plan and specify plan directivesDconfigure a complex resource plan and specify plan directives

多选题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? ()ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed