Oracle Database Administration 2022 Certified Professional — Question 42

You want to reduce the amount of db file scattered read that is generated in the database.
You execute the SQL Tuning Advisor against the relevant workload.
Which two can be part of the expected result? (Choose two.)

Answer options

• A. recommendations regarding the creation of additional indexes
• B. recommendations regarding rewriting the SQL statements
• C. recommendations regarding the creation of materialized views
• D. recommendations regarding the creation of SQL Patches
• E. recommendations regarding partitioning the tables

Correct answer: A, B

Explanation

The SQL Tuning Advisor provides recommendations that enhance SQL performance, which often includes suggestions for creating additional indexes (A) and rewriting SQL statements (B) to optimize execution. The other options, while they may improve performance, are not typically direct outcomes of a SQL Tuning Advisor analysis focused on reducing scattered reads.