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.)
The correct answer is B. generating only execution plans on a test database without actually running SQL statements. D. loading performance data and execution plans from an STS. E. generating both execution plans and statistics for each SQL statement in an STS by actually. https://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_pre_change.htm#RATUG1
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
How the community answered
(46 responses)- A9% (4)
- B72% (33)
- C20% (9)
Explanation
https://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_pre_change.htm#RATUG1
Topics
#SQL Performance Analyzer#SQL Tuning Set#pre-change SQL trial#execution plans
Community Discussion
No community discussion yet for this question.