niusouti.com

单选题What would indicate intra-partition parallelism in an Optimizer Plan?（）A BTQ  B LTQ  C IP  D DTQ

题目
单选题
What would indicate intra-partition parallelism in an Optimizer Plan?（）
A

BTQ  

B

LTQ  

C

IP  

D

DTQ

相似考题

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

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

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

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

更多“单选题What would indicate intra-partition parallelism in an Optimizer Plan?（）A BTQ  B LTQ  C IP  D DTQ”相关问题

  • 第1题：

    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.

    正确答案:C,E

  • 第2题：

    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

    正确答案:C

  • 第3题：

    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

    正确答案:B,D

  • 第4题：

    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.

    正确答案:B

  • 第5题：

    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 version
    • B、to completely avoid the use of new plans generated by a new optimizer version
    • C、to prevent plan capturing when the SQL statement is executed after the database upgrade
    • D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

    正确答案:A

  • 第6题：

    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.

    正确答案:A

  • 第7题：

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


    正确答案： D
    解析： 暂无解析

  • 第8题：

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


    正确答案： A,E
    解析： 暂无解析

  • 第9题：

    单选题
    What you’ve told me of your plan sounds most interesting; would you care to _____ on it?
    A

    elaborate

    B

    explain

    C

    stress

    D

    interrupt


    正确答案： B
    解析：
    elaborate on详细阐述。explain解释，说明。stress强调，着重。interrupt打断。

  • 第10题：

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


    正确答案： B
    解析： 暂无解析

  • 第11题：

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

    B

    to completely avoid the use of new plans generated by a new optimizer version

    C

    to prevent plan capturing when the SQL statement is executed after the database upgrade

    D

    to keep the plan in the plan history so that it can be used when the older version of the optimizer is used


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    What would indicate intra-partition parallelism in an Optimizer Plan?（）
    A

    BTQ  

    B

    LTQ  

    C

    IP  

    D

    DTQ


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:C,E

  • 第14题：

    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、 4
    • B、 5
    • C、 6
    • D、 8

    正确答案:C

  • 第15题：

    What would indicate intra-partition parallelism in an Optimizer Plan?（）

    • A、BTQ  
    • B、LTQ  
    • C、IP  
    • D、DTQ

    正确答案:B

  • 第16题：

    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.

    正确答案:C

  • 第17题：

    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.

    正确答案:A,E

  • 第18题：

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


    正确答案： A
    解析： 暂无解析

  • 第19题：

    多选题
    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


    正确答案： C,B
    解析： 暂无解析

  • 第20题：

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

     4

    B

     5

    C

     6

    D

     8


    正确答案： D
    解析： 暂无解析

  • 第21题：

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


    正确答案： E,B
    解析： 暂无解析

  • 第22题：

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


    正确答案： A
    解析： 暂无解析

  • 第23题：

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


    正确答案： B,C
    解析： 暂无解析

  • 第24题：

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


    正确答案： C
    解析： 暂无解析

相关内容