单选题

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()

A statistics recommendations

B SQL profile recommendations

C index-related recommendations

D restructuring of SQL recommendations

正确答案

来源:www.examk.com

答案解析

相似试题
  • Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()  

    单选题查看答案

  • What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()  

    多选题查看答案

  • Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()

    多选题查看答案

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

    多选题查看答案

  • Which two statements are true regarding the SQL Repair Advisor?() 

    多选题查看答案

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

    单选题查看答案

  • Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?() 

    多选题查看答案

  • Which two statements are true regarding the usage of the SQL*Loader utility()

    多选题查看答案

  • While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?()  

    单选题查看答案

  • What two statements are true regarding the recommendations received from the SQL Access Advisor?()

    多选题查看答案