Oracle
1Z0-064 · Question #13
Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Managing Database Performance
Question
Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)
Options
- Aexecuting SQL statements in an SQL Tuning Set (STS) on a test database by using database
- Bgenerating only execution plans on a test database without actually running SQL statements.
- Cgenerating an execution plan and statistics for selective SQL statements captured in an STS
- Dloading performance data and execution plans from an STS.
- Egenerating both execution plans and statistics for each SQL statement in an STS by actually
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.
Topics
#SQL Performance Analyzer#SQL Tuning Set#pre-change SQL trial#execution plans