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 of the following identifies and creates an index to minimize the DB time for a particular SQL statement?()A. The SGA Tuning AdvisorB. The SQL Access AdvisorC. The SQL Tuning AdvisorD. The Memory Advisor

2.You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor SQL

3. You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）  A、 SQL Access AdvisorB、 Undo AdvisorC、 Segment AdvisorD、 SQL Tuning Advisor

4.Which of the following advisors is run in every maintenance window by the auto－task system?()A. The Memory AdvisorB. The SQL Tuning AdvisorC. The Undo AdvisorD. The SQL Access 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 AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor”相关问题

  • 第1题：

    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

  • 第2题：

    While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

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

    正确答案:C

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    Which tasks are run automatically as part of the Automated Maintenance Task by default？（） 

    • A、 Segment Advisor
    • B、 SQL Access Advisor
    • C、 Optimizer statistics gathering
    • D、 Automatic SQL Tuning Advisor
    • E、 Automatic Database Diagnostics Monitor

    正确答案:A,C,D

  • 第6题：

    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

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

    正确答案:D

  • 第7题：

    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

    • A、The Automatic Memory Manager (AMM)
    • B、The SQL Tuning Advisor
    • C、The Segment Advisor
    • D、The SQL Access Advisor

    正确答案:D

  • 第8题：

    单选题
    You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）
    A

     SQL Access Advisor

    B

     Undo Advisor

    C

     Segment Advisor

    D

     SQL Tuning Advisor


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

  • 第9题：

    单选题
    To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）
    A

     EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor

    B

     EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor

    C

     EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor

    D

     Either B or C

    E

     All of the above


    正确答案： 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 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
    解析： 暂无解析

  • 第12题：

    单选题
    You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）
    A

     SQL Tuning Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     Segment Advisor


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

  • 第13题：

    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

  • 第14题：

    You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

    • A、Run Segment Advisor
    • B、Run the SQL Tuning Advisor (STA)
    • C、Run the Automatic Workload Repository (AWR) report
    • D、Run the SQL Access Advisor with a hypothetical workload

    正确答案:D

  • 第15题：

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

    • A、Database replay
    • B、SQL Tuning Advisor
    • C、SQL Access Advisor
    • D、SQL Performance Analyzer
    • E、Automatic Workload Repository compare reports

    正确答案:E

  • 第16题：

    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

  • 第17题：

    To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  

    • A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor
    • B、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • C、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • D、 Either B or C
    • E、 All of the above

    正确答案:D

  • 第18题：

    Which of the following advisors is run in every maintenance window by the auto-task system?（）

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

    正确答案:B

  • 第19题：

    单选题
    You have a very large table that your users access frequently.  Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）
    A

     The Automatic Memory Manager （AMM）

    B

     The SQL Tuning Advisor

    C

     The Segment Advisor

    D

     The SQL Access Advisor


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

  • 第20题：

    单选题
    While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


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

  • 第21题：

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


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

  • 第22题：

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

  • 第23题：

    单选题
    You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance.  What action must you take to achieve this？（）
    A

     Run Segment Advisor

    B

     Run the SQL Tuning Advisor （STA）

    C

     Run the Automatic Workload Repository （AWR） report

    D

     Run the SQL Access Advisor with a hypothetical workload


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

  • 第24题：

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


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

相关内容