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

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?()

    答案解析

快考试在线搜题