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 inde

题目

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
相似考题

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

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

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

更多“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 inde”相关问题

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

  • 第3题：

    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

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

    正确答案:B

  • 第5题：

    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

  • 第6题：

    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）  

    • A、SQL Access Advisor
    • B、 Memory Advisor
    • C、SQL Tuning Advisor
    • D、 Segment Advisor

    正确答案:A

  • 第7题：

    To view the results of a manual SQL Tuning Advisor task， which steps should the DBA take？（）  

    • A、 From the Advisor Central home page，select the tuning task from the Advisor Tasks section 
    • B、 From Advisor Central，choose SQL Advisors，SQL Tuning Advisors，Manual Tuning Task Results
    • C、 From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task Results
    • D、 Either B or C

    正确答案:A

  • 第8题：

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

  • 第9题：

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

  • 第10题：

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

  • 第11题：

    单选题
    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）
    A

     Segment Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


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

  • 第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?（） (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

  • 第14题：

    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

  • 第15题：

    To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?（）

    • A、From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
    • B、From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
    • C、From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
    • D、Either B or C

    正确答案:A

  • 第16题：

    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）  

    • A、 Segment Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 SQL Tuning Advisor

    正确答案:B

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    单选题
    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
    A

    SQL Access Advisor

    B

     Memory Advisor

    C

    SQL Tuning Advisor

    D

     Segment Advisor


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

  • 第20题：

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


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

  • 第21题：

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

  • 第22题：

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

  • 第23题：

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

相关内容