单选题What would indicate intra-partition parallelism in an Optimizer Plan?（）ABTQ BLTQ CIP DDTQ
单选题
What would indicate intra-partition parallelism in an Optimizer Plan?（）
A
BTQ
B
LTQ
C
IP
D
DTQ
参考解析
解析：
暂无解析
相关考题：
I understand that the governor is considering a new plan_____. A、to cause that the amount of papers written in government offices reducedB、what would eliminate unnecessary writing in governmentC、that would eliminate unnecessary paperwork in governmentD、who want to cut down the amount of writing in government
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is the reason for performing these activities? （）A. to minimize plan regression due to the use of a new optimizer versionB. to completely avoid the use of new plans generated by a new optimizer versionC. to prevent plan capturing when the SQL statement is executed after the database upgradeD. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.
Examine the parameter for your database instance:You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:Identify the reason why the optimizer chose different execution plans.（）A. The optimizer used a dynamic plan for the query.B. The optimizer chose different plans because automatic dynamic sampling was enabled.C. The optimizer used re-optimization cardinality feedback for the query.D. The optimizer chose different plan because extended statistics were created for the columns used.
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.
A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）A、one server having at least two processors B、two servers having one processor and one logical database partition C、one server having four processors and two logical database partitions D、two servers each having four processors and two logical database partitions
During Company.com planning session，Company.com presents the details of the current Network design. The network design serves four separate company facilities， each on as separate subnet. As part of a disaster recovery plan， the customer is evaluating the use of HACMP. Specifically， the have reviewed IPAT via IP aliasing and are questioning the number of IP subnets required. Given the customer’s current configuration，what is the recommended minimum number of IP subnets that would be required？（）A、 4B、 5C、 6D、 8
In which two environments would intra-partition parallelism be used? （）A、Single database partition, single processor B、Single database partition, multiple processors C、Multiple database partitions, single processor D、Multiple database partitions, multiple processors
Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）A、The optimizer used a dynamic plan for the query.B、The optimizer chose different plans because automatic dynamic sampling was enabled.C、The optimizer used re-optimization cardinality feedback for the query.D、The optimizer chose different plan because extended statistics were created for the columns used.
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements. What would you do with these SQL statements？（）A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B、 Capture the plans from the previous version using STS and then load them into the stored outline.C、 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）A、The optimizer adds the new plan to the plan history.B、The optimizer selects the new plan for the execution of the SQL statement.C、The optimizer adds the new plan to the SQL plan baseline as an accepted plan.D、The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.E、The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
You work as the exchange administrator at TestKing.com. The TestKing.com network contains an Exchange Server 2010 Organization. TestKing.com has its headquarters in Chicago and a branch office in Dallas. During the course of day you receive an instruction form the CIO to ensure that confidential data is not forwarded on the Internet. What should you do？（）A、Your best option would be to include Transport Protection Rules in your plan.B、Your best option would be to include a custom Send connector in you plan.C、Your best option would be to include custom MailTips in you plan.D、Your best option would be to include Role Based Access Control （RBAC） role entries in your plan.
单选题You work as the exchange administrator at TestKing.com. The TestKing.com network contains an Exchange Server 2010 Organization. TestKing.com has its headquarters in Chicago and a branch office in Dallas. During the course of day you receive an instruction form the CIO to ensure that confidential data is not forwarded on the Internet. What should you do？（）AYour best option would be to include Transport Protection Rules in your plan.BYour best option would be to include a custom Send connector in you plan.CYour best option would be to include custom MailTips in you plan.DYour best option would be to include Role Based Access Control （RBAC） role entries in your plan.
单选题A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）Aone server having at least two processors Btwo servers having one processor and one logical database partition Cone server having four processors and two logical database partitions Dtwo servers each having four processors and two logical database partitions
多选题In which two environments would intra-partition parallelism be used? （）ASingle database partition, single processorBSingle database partition, multiple processorsCMultiple database partitions, single processorDMultiple database partitions, multiple processors
多选题The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）AThe optimizer adds the new plan to the plan history.BThe optimizer selects the new plan for the execution of the SQL statement.CThe optimizer adds the new plan to the SQL plan baseline as an accepted plan.DThe optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.EThe optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
单选题During Company.com planning session，Company.com presents the details of the current Network design. The network design serves four separate company facilities， each on as separate subnet. As part of a disaster recovery plan， the customer is evaluating the use of HACMP. Specifically， the have reviewed IPAT via IP aliasing and are questioning the number of IP subnets required. Given the customer’s current configuration，what is the recommended minimum number of IP subnets that would be required？（）A 4B 5C 6D 8
单选题What you’ve told me of your plan sounds most interesting; would you care to _____ on it?AelaborateBexplainCstressDinterrupt
多选题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.
单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）ASet OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.BCapture the plans from the previous version using STS and then load them into the stored outline.CCapture the plans from the previous version using STS and then load them into SQL Management Base (SMB).DSet OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
单选题Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）AThe optimizer used a dynamic plan for the query.BThe optimizer chose different plans because automatic dynamic sampling was enabled.CThe optimizer used re-optimization cardinality feedback for the query.DThe optimizer chose different plan because extended statistics were created for the columns used.
单选题You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）Ato minimize plan regression due to the use of a new optimizer versionBto completely avoid the use of new plans generated by a new optimizer versionCto prevent plan capturing when the SQL statement is executed after the database upgradeDto keep the plan in the plan history so that it can be used when the older version of the optimizer is used
多选题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.
单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements. What would you do with these SQL statements？（）A Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B Capture the plans from the previous version using STS and then load them into the stored outline.C Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）D Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.