OCP-1Z0-053-V12.02-159题

 

159.Which package provides API's for the SQL Tuning Advisor?

A. DBMS_MONITOR

B. DBMS_STATS

C. DBMS_SQLTUNE

D. DBMS_ADVISOR

Answer: C

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF94855

Running SQL Tuning Advisor

The recommended interface for running SQL Tuning Advisor is Enterprise Manager. Whenever possible, run SQL Tuning Advisor using Enterprise Manager, . If Enterprise Manager is unavailable, then you can run SQL Tuning Advisor using procedures in the DBMS_SQLTUNE package. To use the APIs, the user must be granted specific privileges.

Running SQL Tuning Advisor using DBMS_SQLTUNE package is a multi-step process:

1. Create a SQL tuning set (if tuning multiple SQL statements)

2. Create a SQL tuning task

3. Execute a SQL tuning task

4. Display the results of a SQL tuning task

5. Implement recommendations as appropriate