（369）Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?

A. The SGA Tuning Advisor

B. The SQL Access Advisor

C. The SQL Tuning Advisor

D. The Memory Advisor

答案：（B）

解析：

答案解析：

The SQL Access Advisor is primarily responsible for making schema modification recommendations.

It can recommend that you create access structures such as indexes and materialized views to optimize SQL queries.

It can also recommend that you partition tables,indexes,or materialized views to improve query performance.

ITPub博客

Oracle 11G OCP 1Z0-053 369