Which package provides API’s for the SQL Tuning Advisor?
Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)
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?
Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?
Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?
To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?