Prev Question
Next 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?

A. Complete Oracle Enterprise Manager suite

B. SQL Performance Analyzer which helps predict and prevent SQL execution performance problems
caused by environment changes

C. SQL Plan Manager which uses system histograms to extrapolate future SQL execution performance

D. Oracle Database Backup & Recovery

E. Oracle SQL Developer, which helps develop and test the SQL prior to putting it into production

Explanation:

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *