Oracle 11G OCP 1Z0-053 369

(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.

请使用浏览器的分享功能分享到微信等