niusouti.com

单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）A Segment AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor

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

相似考题

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 of the following is a potential performance tuning recommendation from the SQL Access Advisor?()A. Create new indexes.B. Modify existing indexes.C. Implement partitioning on a nonpartitioned table.D. Create materialized views.E. All of the above

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

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

参考答案和解析
正确答案： A
解析： 暂无解析
更多“Which tuning tool recommends how to optimize materialized vi”相关问题

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

    The Chief Information Officer （CIO） is preparing a briefing about the reliability of their server environment.  There is a need to create a report about which systems had unplanned system outages and how often they occurred.  What IBM Director tool can be used to create the report？（）

    • A、Capacity Manager
    • B、Process Management tool
    • C、System Availability tool
    • D、System Reporting tool

    正确答案:C

  • 第4题：

    Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）  

    • A、 The SGA Tuning Advisor
    • B、 The SQL Access Advisor
    • C、 The SQL Tuning Advisor
    • D、 The Memory Advisor

    正确答案:C

  • 第5题：

    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）  

    • A、 Create new indexes.
    • B、 Modify existing indexes.
    • C、 Implement partitioning on a nonpartitioned table.
    • D、 Create materialized views.
    • E、 All of the above

    正确答案:E

  • 第6题：

    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

  • 第7题：

    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,C

  • 第8题：

    单选题
    A customer is running system management software on one of their Windows xSeries servers， and the software seems to slow down their database application over time.  The customer is running IBM Director in their environment.  Which IBM Director tool can they utilize to guarantee processor time for the different applications and optimize the server performance？（）
    A

    Software Rejuvenation

    B

    Capacity Manager

    C

    Capacity Workload Manager

    D

    Aurema Application Workload Manager


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

  • 第9题：

    单选题
    You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?（）
    A

    Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE

    B

    Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE

    C

    Use compression when performing tape backups

    D

    Configure multiple SBT channels


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

  • 第10题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked.  Which tool should you use? （）
    A

    You should use the Database Engine Tuning Advisor tool 

    B

    You should use the Windows System Monitor tool 

    C

    You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio 

    D

    You should use the Activity Monitor tool in Microsoft SQL Server Management Studio


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

  • 第11题：

    单选题
    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）
    A

     Create new indexes.

    B

     Modify existing indexes.

    C

     Implement partitioning on a nonpartitioned table.

    D

     Create materialized views.

    E

     All of the above


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

  • 第12题：

    单选题
    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）
    A

    ADDM

    B

    AWR

    C

    Cursor Cache

    D

    SQL Tuning Sets

    E

    Flash Recovery Area


    正确答案： 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题：

    Which of the following would BEST optimize a computer that is heavily used? （）

    • A、Scandisk
    • B、Defrag
    • C、Indexing
    • D、Chkdsk

    正确答案:B

  • 第15题：

    Which IBM Resource would best help you determine the proper performance tuning of your System x hardware and the application workload of the software？（）

    • A、xREF Sheets
    • B、IBM Sizing Guides
    • C、Configuration & Options Guide - （COG）
    • D、Standalone Solutions Configuration Tool （SSCT）

    正确答案:B

  • 第16题：

    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）  

    • A、ADDM
    • B、AWR
    • C、Cursor Cache
    • D、SQL Tuning Sets
    • E、Flash Recovery Area

    正确答案:E

  • 第17题：

    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

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

    单选题
    You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）
    A

     Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE

    B

     Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE

    C

     Use compression when performing tape backups

    D

     Configure multiple SBT channels


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

  • 第20题：

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

  • 第21题：

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

  • 第22题：

    单选题
    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）
    A

    Create new indexes.

    B

    Modify existing indexes.

    C

    Implement partitioning on a nonpartitioned table.

    D

    Create materialized views.

    E

    All of the above


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

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

  • 第24题：

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


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

相关内容