053-641
Which three functions are performed by the SQL Tuning Advisor? (Choose three.)
A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans
此题考点是 SQL 优化指导 ,sql 优化指导的建议分为以下几类:
•统计信息分析 C 正确
•SQL profile A 正确
•访问路径分析
•SQL 结构分析 E 正确
B,C 错误。这 2 个是 sql 访问指导的功能