38.The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor 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
题意是：你的数据库实例的SQL调优顾问配置为默认设置。哪一个建议是作为自动维护任务的一部分SQL调优顾问运行后自动实现的？
SQL概要文件建议。
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF95161
A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations
Answer: B
题意是：你的数据库实例的SQL调优顾问配置为默认设置。哪一个建议是作为自动维护任务的一部分SQL调优顾问运行后自动实现的？
SQL概要文件建议。
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF95161
During SQL tuning, you select a statement for automatic tuning and run SQL Tuning Advisor. The database can profile the following types of statement:
-
DML statements (SELECT, INSERT with a SELECT clause, UPDATE, and DELETE)
-
CREATE TABLE statements (only with the AS SELECT clause)
-
MERGE statements (the update or insert operations)
SQL Tuning Advisor invokes Automatic Tuning Optimizer to generate recommendations. Recommendations to accept SQL profiles occur in a finding.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2121075/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q47
下一篇：
1Z0-053 V13.02 Q39
请登录后发表评论
登录
全部评论
