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?()
多选题查看答案