Multiple choice

Which of the following is/are applicable for SQL tuning advisor in automatic performance tuning of oracle database?

  1. It allows a quick and efficient technique for optimizing SQL statements.

  2. It collects, processes and maintains performance statistics for problem detection.

  3. It provides advice on materialized views, indexes, and materialized view logs.

  4. It analyses the information from the Automatic Workload Repository (AWR) for possible performance problems with the Oracle database.

  5. Both (1) and (3)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL Tuning Advisor provides SQL optimization without modifying any statements.

Keep practicing — related questions