OCP-1Z0-053-200题-161题-262
来源:互联网 发布:网络作家收入榜 编辑:程序博客网 时间:2024/05/16 18:30
QUESTION 161
In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
Answer: ACDE
同262题:http://blog.csdn.net/rlhua/article/details/19037831
Explanation/Reference:
Section: Managing Database Performance & Tuning
In Oracle 11g, the SQL Access Advisor can generate partitioning recommendations, index creation
recommendations, materialized view recommendations,and materialized view log recommendations. The SQL
Access Advisor is a tuning tool that provides advice regarding the tuning of materialized views, indexes(Btree,
bitmap, and function-based), and materialized view logs, as well as advice on table and index partitioning.
The SQL Access Advisor provides recommendations by analyzing a known workload and other specified
information. SQL Access Advisor does not generate statistics collection recommendations. This task is
performed by the SQL Tuning Advisor.
- OCP-1Z0-053-200题-161题-262
- OCP-1Z0-053-200题-108题-161
- OCP-1Z0-053-200题-200题-61
- OCP-1Z0-053-V13.02-262题
- OCP-1Z0-053-V12.02-161题
- OCP-1Z0-053-200题-1题-677
- OCP-1Z0-053-200题-4题-88
- OCP-1Z0-053-200题-2题-86
- OCP-1Z0-053-200题-3题-87
- OCP-1Z0-053-200题-5题-89
- OCP-1Z0-053-200题-6题-90
- OCP-1Z0-053-200题-7题-91
- OCP-1Z0-053-200题-8题-92
- OCP-1Z0-053-200题-9题-93
- OCP-1Z0-053-200题-10题-94
- OCP-1Z0-053-200题-11题-95
- OCP-1Z0-053-200题-12题-96
- OCP-1Z0-053-200题-13题-97
- Hadoop YARN常见问题以及解决方案
- decimal system 2106
- java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序 问题
- bat在不同目录下执行一系列bat并修改只读权限
- Yii Framwork在ActiveRecord自动化记录时间戳
- OCP-1Z0-053-200题-161题-262
- 简单字符串比较
- 软件工程视频之软件设计
- Hadoop YARN 基本架构和发展趋势
- fzu 2113 Jason的特殊爱好 && hdu 2089 不要62 ( 数位dp )
- Android异常:Binary XML file line#51:Error inflating class checkBok
- 现代的Dojo(相对于1.6版本)<5>
- 简单字符串排序
- “Word.Tables”并不包含“Item”的定义的解决办法