多选题What two statements are true regarding the recommendations received from the SQL Access Advisor？（）AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some 

题目
多选题
What two statements are true regarding the recommendations received from the SQL Access Advisor？（）
A

It cannot generate recommendations that support multiple workload queries.

B

It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

C

It can recommend partitioning only on tables that have at least 10，000 rows.

D

It can recommend only B-tree indexes and not bitmap or function-based indexes.

相似考题

1.In Oracle 11g, which recommendations does the SQL Access Advisor generate?()A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations

2.In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations

3.Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types

4.What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()A. selection of SQL plan baselinesB. partitioning of tables and indexesC. creation of index-organized tablesD. creation of bitmap, function-based, and B-tree indexesE. optimization of materialized views for maximum query usage and fast refresh

更多“多选题What two statements are true regarding the recommendations received from the SQL Access Advisor？（）AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some ”相关问题

  • 第1题：

    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

    • A、 Top SQL
    • B、 snapshots
    • C、 SQL Tuning sets
    • D、 index access path
    • E、 optimizer statistics
    • F、 materialized view logs

    正确答案:A,C,D

  • 第2题：

    What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)

    • A、It cannot generate recommendations that support multiple workload queries.
    • B、It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
    • C、It can recommend partitioning only on tables that have at least 10,000 rows.
    • D、It can recommend only B-tree indexes and not bitmap or function-based indexes

    正确答案:B,C

  • 第3题：

    What happens when you run the SQL Tuning Advisor with limited scope?（）

    • A、Access path analysis is not performed for SQL statements.
    • B、SQL structure analysis is not performed for SQL statements.
    • C、SQL Profile recommendations are not generated for SQL statements.
    • D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

    正确答案:B,C

  • 第4题：

    In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）

    • A、partitioning recommendations
    • B、statistics collection recommendations
    • C、index creation recommendations
    • D、materialized view recommendations
    • E、materialized view log recommendations

    正确答案:A,C,D,E

  • 第5题：

    Which three statements about performance analysis by SQL Performance Analyzer are true？（）

    • A、 It detects changes in SQL execution plans.
    • B、 It produces results that can be used to create the SQL plan baseline.
    • C、 The importance of SQL statements is based on the size of the objects accessed.
    • D、 It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
    • E、 It shows only the overall impact on workload and not the net SQL impact on workload.

    正确答案:A,B,D

  • 第6题：

    What two statements are true regarding the recommendations received from the SQL Access Advisor？（）

    • A、 It cannot generate recommendations that support multiple workload queries.
    • B、 It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
    • C、 It can recommend partitioning only on tables that have at least 10，000 rows.
    • D、 It can recommend only B-tree indexes and not bitmap or function-based indexes.

    正确答案:B,C

  • 第7题：

    多选题
    What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)
    A

    It cannot generate recommendations that support multiple workload queries.

    B

    It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

    C

    It can recommend partitioning only on tables that have at least 10,000 rows.

    D

    It can recommend only B-tree indexes and not bitmap or function-based indexes


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

  • 第8题：

    多选题
    Which two statements are true regarding the USING clause in table joins?（）
    A

    It can be used to join a maximum of three tables

    B

    It can be used to restrict the number of columns used in a NATURAL join

    C

    It can be used to access data from tables through equijoins as well as nonequijoins

    D

    It can be used to join tables that have columns with the same name and compatible data types


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

  • 第9题：

    多选题
    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
    A

    Top SQL

    B

    snapshots

    C

    SQL Tuning sets

    D

    index access path

    E

    optimizer statistics

    F

    materialized view logs


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

  • 第10题：

    多选题
    In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)
    A

    partitioning recommendations

    B

    statistics collection recommendations

    C

    index creation recommendations

    D

    materialized view recommendations

    E

    materialized view log recommendations


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

  • 第11题：

    多选题
    When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)
    A

    It produces less accurate results of the comparison analysis.

    B

    It automatically calls the SQL Tuning Advisor for recommendations.

    C

    It shortens the time of execution and reduces the impact on system resources.

    D

    Only the changes in the execution plan, and not performance regression, are detected.


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

  • 第12题：

    多选题
    In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）
    A

    partitioning recommendations

    B

    statistics collection recommendations

    C

    index creation recommendations

    D

    materialized view recommendations

    E

    materialized view log recommendations


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

  • 第13题：

    Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

    • A、Access path analysis is not performed for the SQL statements.
    • B、SQL structure analysis is not performed for the SQL statements.
    • C、SQL Profile recommendations are not generated for the SQL statements.
    • D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

    正确答案:C

  • 第14题：

    What happens when you run the SQL Tuning Advisor with limited scope？（）  

    • A、 Access path analysis is not performed for SQL statements.
    • B、 SQL structure analysis is not performed for SQL statements.
    • C、 SQL Profile recommendations are not generated for SQL statements.
    • D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

    正确答案:B

  • 第15题：

    Which statement most accurately describes the implementation of a SQL Access Advisor recommendation？（）  

    • A、 SQL Access Advisor recommendations are automatically implemented.
    • B、 Individual SQL Access Advisor recommendations can be scheduled for implementation.
    • C、 All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
    • D、 SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
    • E、 None of the above.

    正确答案:B

  • 第16题：

    What recommendations does the SQL Access Advisor provide for optimizing SQL queries? （）(Choose all that apply.)

    • A、selection of SQL plan baselines
    • B、partitioning of tables and indexes
    • C、creation of index-organized tables
    • D、creation of bitmap, function-based, and B-tree indexes
    • E、optimization of materialized views for maximum query usage and fast refresh

    正确答案:B,D,E

  • 第17题：

    What recommendations does the SQL Access Advisor provide for optimizing SQL queries？（）  

    • A、 selection of SQL plan baselines
    • B、 partitioning of tables and indexes
    • C、 creation of index-organized tables
    • D、 creation of bitmap， function-based，and B-tree indexes
    • E、 optimization of materialized views for maximum query usage and fast refresh

    正确答案:B,D,E

  • 第18题：

    In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)

    • A、partitioning recommendations
    • B、statistics collection recommendations
    • C、index creation recommendations
    • D、materialized view recommendations
    • E、materialized view log recommendations

    正确答案:A,C,D,E

  • 第19题：

    多选题
    Which three statements about performance analysis by SQL Performance Analyzer are true? （）(Choose three.)
    A

    It detects changes in SQL execution plans.

    B

    It produces results that can be used to create the SQL plan baseline.

    C

    The importance of SQL statements is based on the size of the objects accessed.

    D

    It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

    E

    It shows only the overall impact on workload and not the net SQL impact on workload.


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

  • 第20题：

    多选题
    What two statements are true regarding the recommendations received from the SQL Access Advisor？（）
    A

    It cannot generate recommendations that support multiple workload queries.

    B

    It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

    C

    It can recommend partitioning only on tables that have at least 10，000 rows.

    D

    It can recommend only B-tree indexes and not bitmap or function-based indexes.


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

  • 第21题：

    单选题
    Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?（）
    A

    SQL Access Advisor recommendations are automatically implemented.

    B

    Individual SQL Access Advisor recommendations can be scheduled for implementation.

    C

    All SQL Access Advisor recommendations for a specific task must be implemented at the same time.

    D

    SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.

    E

    None of the above.


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

  • 第22题：

    多选题
    What happens when you run the SQL Tuning Advisor with limited scope?（）
    A

    Access path analysis is not performed for SQL statements.

    B

    SQL structure analysis is not performed for SQL statements.

    C

    SQL Profile recommendations are not generated for SQL statements.

    D

    Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.


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

  • 第23题：

    多选题
    Which three statements about performance analysis by SQL Performance Analyzer are true？（）
    A

    It detects changes in SQL execution plans.

    B

    It produces results that can be used to create the SQL plan baseline.

    C

    The importance of SQL statements is based on the size of the objects accessed.

    D

    It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

    E

    It shows only the overall impact on workload and not the net SQL impact on workload.


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

  • 第24题：

    多选题
    When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics.  Which two statements describe the implications of this？（）
    A

    It produces less accurate results of the comparison analysis.

    B

    It automatically calls the SQL Tuning Advisor for recommendations.

    C

    It shortens the time of execution and reduces the impact on system resources.

    D

    Only the changes in the execution plan，and not performance regression，are detected.


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

相关内容