Oracle
1Z0-054 · Question #26
1Z0-054 Question #26: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.
Question
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version that contains important SQL statements. You are not sure about the elapsed time that the SQL statements will have in the new system due to the version change of the optimizer. Which tool provides a comparative report with respect to the elapsed time in both versions of the optimizer?
Options
- ASQL Access Advisor
- BSQL Tuning Advisor (STA)
- CSQL Performance Analyzer (SPA)
- DAutomatic Workload Repository (AWR) compare period report
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.