Oracle Global Human Resources Cloud 2016 Implementation Specialist — Question 10

Which one would SQL Access Advisor use as input to provide a recommendation on a partition or index?

Answer options

• A. SQL Tuning Advisor
• B. Automatic Workload Repository
• C. Automatic Diagnostic Monitor
• D. SQL Tuning Set
• E. SQL Errors

Correct answer: A

Explanation

The SQL Access Advisor relies on the SQL Tuning Advisor as its source of input to provide insights into optimizing partitions or indexes. Other options like the Automatic Workload Repository and SQL Tuning Set, while useful for performance analysis, do not directly serve as input for the SQL Access Advisor's recommendations.