多选题What recommendations does the SQL Access Advisor provide for optimizing SQL queries?（）Aselection of SQL plan baselinesBpartitioning of tables and indexesCcreation of index-organized tablesDcreation of bitmap, function-based, and B-tree indexesEoptimiza

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

相似考题

1.Which three functions are performed by the SQL Tuning Advisor? ()A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plans

2.What recommendations does the SQL Access Advisor provide for optimizing SQL queries? ()(Choose all that apply.)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

3.Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plans

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 recommendations does the SQL Access Advisor provide for optimizing SQL queries?（）Aselection of SQL plan baselinesBpartitioning of tables and indexesCcreation of index-organized tablesDcreation of bitmap, function-based, and B-tree indexesEoptimiza”相关问题

  • 第1题：

    Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)

    • A、Building the SQL profile
    • B、Recommending optimization of materialized views
    • C、Checking query objects for missing and stale statistics
    • D、Recommending bitmap, function-based, and B-tree indexes
    • E、Recommending restructuring SQL queries that are using bad plans

    正确答案:A,C,E

  • 第2题：

    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

    • A、SQL Repair Advisor
    • B、SQL Optimizer
    • C、SQL Access Advisor
    • D、SQL Tuning Advisor

    正确答案:D

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

    正确答案:B

  • 第4题：

    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

  • 第5题：

    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

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


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

  • 第8题：

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


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

  • 第9题：

    多选题
    Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)
    A

    Building the SQL profile

    B

    Recommending optimization of materialized views

    C

    Checking query objects for missing and stale statistics

    D

    Recommending bitmap, function-based, and B-tree indexes

    E

    Recommending restructuring SQL queries that are using bad plans


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

  • 第10题：

    单选题
    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）
    A

     SQL Repair Advisor

    B

     SQL Optimizer

    C

     SQL Access Advisor

    D

     SQL Tuning Advisor


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

  • 第11题：

    多选题
    Which three functions are performed by the SQL Tuning Advisor？（）
    A

    Building the SQL profile

    B

    Recommending optimization of materialized views

    C

    Checking query objects for missing and stale statistics

    D

    Recommending bitmap， function-based， and B-tree indexes

    E

    Recommending restructuring SQL queries that are using bad plans


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

  • 第12题：

    多选题
    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
    解析： 暂无解析

  • 第13题：

    Which three functions are performed by the SQL Tuning Advisor?（）

    • A、Building and implementing SQL profiles
    • B、Recommending the optimization of materialized views
    • C、Checking query objects for missing and stale statistics
    • D、Recommending bitmap, function-based, and B-tree indexes
    • E、Recommending the restructuring of SQL queries that are using bad plans

    正确答案:A,C,E

  • 第14题：

    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

  • 第15题：

    Which three functions are performed by the SQL Tuning Advisor？（） 

    • A、 Building the SQL profile
    • B、 Recommending optimization of materialized views
    • C、 Checking query objects for missing and stale statistics
    • D、 Recommending bitmap， function-based， and B-tree indexes
    • E、 Recommending restructuring SQL queries that are using bad plans

    正确答案:A,C,E

  • 第16题：

    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

  • 第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题：

    多选题
    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
    解析： 暂无解析

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    多选题
    Which three functions are performed by the SQL Tuning Advisor?（）
    A

    Building and implementing SQL profiles

    B

    Recommending the optimization of materialized views

    C

    Checking query objects for missing and stale statistics

    D

    Recommending bitmap, function-based, and B-tree indexes

    E

    Recommending the restructuring of SQL queries that are using bad plans


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

  • 第21题：

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


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    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
    解析： 暂无解析

  • 第24题：

    多选题
    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
    解析： 暂无解析

相关内容