首页计算机考试Oracle认证
(单选题)

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    Which package provides API’s for the SQL Tuning Advisor?()

    答案解析

  • (多选题)

    Which three functions are performed by the SQL Tuning Advisor?() 

    答案解析

  • (单选题)

    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()  

    答案解析

  • (单选题)

    Which of these appropriately describes the results of a manual SQL Tuning Advisor task?()  

    答案解析

  • (多选题)

    Which of the following cannot be used as input to the SQL Tuning Advisor?()

    答案解析

  • (单选题)

    Which statement is true when you run the SQL Tuning Advisor with limited scope?()

    答案解析

  • (多选题)

    You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()

    答案解析

  • (单选题)

    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()  

    答案解析

  • (单选题)

    You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set?()

    答案解析

  • (单选题)

    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?()

    答案解析

快考试在线搜题