Quiz 1Z0-053

Quiz 1Z0-053, Oracle Database 11g: Administration II

Which three statements about performance analysis by SQL Performance Analyzer are true?

What must you do to receive recommendations on efficient use of indexes and materialized views to improve query performance?

Which is the correct sequence of the required steps?

Which of the following cannot be used as input to the SQL Tuning Advisor?

what client request information is gathered?

Which of the following advisors is run in every maintenance window by the auto-task system?

What action must you take to achieve this?

Which three functions are performed by the SQL Tuning Advisor?

Which two statements regarding a SQL profile are true?

Which two changes and their effect on the system can be tested by using the Database Replay feature?