网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）
A
The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B
The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C
The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D
If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.
E
Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.
参考答案
参考解析
解析：
暂无解析
更多 “多选题In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.EIs a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.” 相关考题
考题
A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database. Which of the following statements best describes the need for custom resource monitor？（） A、 Multiple application servers must be in a single resource group.B、 Multiple application servers per resource group may be monitored.C、 Multiple resource groups must each contain a single application server.D、 Multiple application servers in a cluster cannot use process monitoring.
考题
You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4. Consumer group MARKETwith CPU_P1as 20. Consumer group DEVwith CPU_P1as 20. Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100. Which two statements are correct in this scenario？（）A、 The maximum degree of parallelism for the members of the consumer groups is 4.B、 The CPU allocation will always be equal for the consumer groups MARKET and DEV.C、 The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.D、 The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.E、 The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.
考题
You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20. Consumer group DEV with CPU_P1 as 20. Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100. Which two statements are correct in this scenario？ （）A、The maximum degree of parallelism for the members of the consumer groups is 4.B、The CPU allocation will always be equal for the consumer groups MARKET and DEV.C、The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.D、The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.E、The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.
考题
An administrator is planning a cluster running applications in 3 separate resource groups. RGA - Database 1 RGB - Web Server RGC - Database 2 Database 1 and Database 2 must be online before the Web Server. All resource groups have a Startup Policyof Online on Home Node Only. Which of the following will ensure that the resource groups are processed in the correct order？（）A、Set the Serial Acquisition OrderB、Set the Parallel Acquisition OrderC、Configure Online on the Same Node DependencyD、Configure Online on Different Nodes Dependency
考题
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$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP
考题
Using Oracle Scheduler you have scheduled two jobs， JOB_Aand 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 window group must have been created with the WEEKEND_PLAN resource plan.
考题
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently？（） A、 parallel image copy backupB、 backup with MAXPIECESIZE configured for the channelC、 parallel backup with MAXPIECESIZE configured for the channeD、 intrafile parallel backup
考题
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
考题
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.
考题
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 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 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
考题
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）A、Set a threshold for the default system-defined moving window baseline.B、Add directives to the Automatic Database Diagnostic Monitor (ADDM).C、Modify the profile for the targeted users for which control needs to be imposed.D、Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
考题
In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）A、The parallel degree limit for DB_GRP will be the minimum of all the incoming values.B、The parallel degree limit for DB_GRP will be the maximum of all the incoming values.C、The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.D、If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.E、If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.
考题
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
考题
多选题You plan to execute the following command to perform a Flashback Database operation in your database： SQL FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation
考题
多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）AThe command restores only the missing control file.BThe command restores all the control files.CThe command fails because the database is running.DThis is the correct way to address this problem.EThis is not the correct way to address this problem.
考题
多选题In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.EIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.
考题
多选题In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.EIs a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.
考题
单选题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
考题
多选题You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4. Consumer group MARKETwith CPU_P1as 20. Consumer group DEVwith CPU_P1as 20. Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100. Which two statements are correct in this scenario？（）AThe maximum degree of parallelism for the members of the consumer groups is 4.BThe CPU allocation will always be equal for the consumer groups MARKET and DEV.CThe OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.DThe SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.EThe maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.
考题
多选题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
考题
多选题You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20. Consumer group DEV with CPU_P1 as 20. Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100. Which two statements are correct in this scenario？ （）AThe maximum degree of parallelism for the members of the consumer groups is 4.BThe CPU allocation will always be equal for the consumer groups MARKET and DEV.CThe OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.DThe SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.EThe maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.
考题
单选题You have created a resource plan， PROD_DB_PLAN， that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan： Consumer group HIGH_CG with CPU_P1 as 10. Consumer group MEDIUM_CG with CPU_P1 as 5. Consumer group LOW_CG with CPU_P1 as 2. Consumer group OTHER_GROUPS with CPU_P1 as 1. Which statement is correct in this scenario？（）A
The plan PROD_DB_PLAN can have subplans.B
The members of the HIGH_CG consumer group would get 10% of the CPU.C
The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.D
The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.
考题
单选题A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database. Which of the following statements best describes the need for custom resource monitor？（）A
Multiple application servers must be in a single resource group.B
Multiple application servers per resource group may be monitored.C
Multiple resource groups must each contain a single application server.D
Multiple application servers in a cluster cannot use process monitoring.
考题
单选题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
考题
多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.
考题
单选题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$SYSSTATB
V$SESSSTATC
V$RSRC_PLAND
V$RSRC_CONSUMER_GROUP
考题
多选题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.
热门标签
最新试卷