OCP-1Z0-053-200题-102题-38

来源:互联网 发布:上汽大众 知乎 编辑:程序博客网 时间:2024/05/16 11:29

QUESTION 102

The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation

is automatically implemented after the SQL Tuning Adv isor is run as part of the automatic maintenance task?

A. statistics recommendations

B. SQL Profile recommendations

C. Index-related recommendations

D. restructuring of SQL recommendations

Answer: B

同38题:http://blog.csdn.net/rlhua/article/details/14089909


Explanation/Reference:

Section: Managing Database Performance & Tuning

http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDIBFGA

During the tuning process, all recommendation typesare considered and reported, but only SQL profiles can

be implemented automatically.

0 0