Oracle
1Z0-417 · Question #77
DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team. What would…
The correct answer is B. SQL Performance Analyzer which helps predict and prevent SQL execution performance problems. See the full explanation below for the reasoning.
Question
DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team. What would you implement to resolve this problem?
Options
- AComplete Oracle Enterprise Manager suite
- BSQL Performance Analyzer which helps predict and prevent SQL execution performance problems
- CSQL Plan Manager which uses system histograms to extrapolate future SQL execution
- DOracle Database Backup & Recovery
- EOracle SQL Developer, which helps develop and test the SQL prior to putting it into production
How the community answered
(26 responses)- B81% (21)
- C4% (1)
- D12% (3)
- E4% (1)
Community Discussion
No community discussion yet for this question.