Oracle
1Z0-043 · Question #33
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze?…
The correct answer is A. Top SQL B. snapshots C. SQL Tuning sets. See the full explanation below for the reasoning.
Question
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze? (Choose three.)
Options
- ATop SQL
- Bsnapshots
- CSQL Tuning sets
- Dindex access path
- Eoptimizer statistics
- Fmaterialized view logs
How the community answered
(30 responses)- A73% (22)
- D3% (1)
- E17% (5)
- F7% (2)
Community Discussion
No community discussion yet for this question.