多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view

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

相似考题

1.View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

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

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

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

更多“多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

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

    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

  • 第7题：

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

  • 第8题：

    单选题
    The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）
    A

    statistics recommendations

    B

    SQL Profile recommendations

    C

    Index-related recommendations

    D

    restructuring of SQL recommendations


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

  • 第9题：

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


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

  • 第10题：

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

  • 第11题：

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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)

    • A、A single SQL statement provided by a user
    • B、An existing SQL Tuning Set (STS)
    • C、A preprocessed Database Replay workload
    • D、A schema name
    • E、SQL statement identified in EM as using excessive resources

    正确答案:C,D

  • 第16题：

    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

  • 第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 of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)
    A

    A single SQL statement provided by a user

    B

    An existing SQL Tuning Set (STS)

    C

    A preprocessed Database Replay workload

    D

    A schema name

    E

    SQL statement identified in EM as using excessive resources


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

  • 第20题：

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

  • 第21题：

    多选题
    Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)
    A

    Segment Advisor

    B

    SQL Access Advisor

    C

    Optimizer statistics gathering

    D

    Automatic SQL Tuning Advisor

    E

    Automatic Database Diagnostics Monitor


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

  • 第22题：

    单选题
    View the Exhibit and examine the highlighted alert. You have received an alert with the Category specified as Snapshot Too Old. Which page would you open from the Advisor Central page to determine the system recommendations to avoid such alerts in future?（）
    A

    ADDM 

    B

    Memory Advisor 

    C

    Segment Advisor 

    D

    Undo Management 

    E

    SQL Tuning Advisor 

    F

    SQL Access Advisor


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

  • 第23题：

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

  • 第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
    解析： 暂无解析

相关内容