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
正确答案
答案解析
相似试题
(单选题)
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?()