PrepAway - Latest Free Exam Questions & Answers

Which application tuning sequence is correct?

You receive an application from the development department, and you detect there is a new issue
causing poor performance.
Which application tuning sequence is correct?

PrepAway - Latest Free Exam Questions & Answers

A.
1. identify long-running queries and statements
2. analyze query using RDBMS tools
3. locate corresponding query in the log
4. trace slow operations
5. tune query by re-composition or adding indexes

B.
1. trace slow operations
2. identify long-running queries and statements
3. locate corresponding query in the log
4. analyze query using RDBMS tools
5. tune query by re-composition or adding indexes

C.
1. tune query by re-composition or adding indexes
2. locate corresponding query in the log
3. trace slow operations
4. identify long-running queries and statements
5. analyze query using RDBMS tools

D.
1. locate corresponding query the session log
2. analyze query using RDBMS tools
3. tune query by re-composition or adding indexes
4. identify long-running queries and statements
5. trace slow operations


Leave a Reply