单项选择题
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）
A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor
点击查看答案
相关考题
-
单项选择题
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
A. The Automatic Memory Manager (AMM)
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor -
多项选择题
Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor -
多项选择题
What recommendations does the SQL Access Advisor provide for optimizing SQL queries? （）(Choose all that apply.)
A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh
