053-16 Which statement most accurately describes the implementation of a SQL Access Advisor recommen
来源:互联网 发布:大数据产品市场份额 编辑:程序博客网 时间:2024/04/29 23:40
QUESTION 16
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?
A. SQL Access Advisor recommendations are automatically implemented.
B. Individual SQL Access Advisor recommendations can be scheduled for implementation.
C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D. SQL Access Advisor recommendations are automatically scheduled for implementation during the
maintenance window.
The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?
A. SQL Access Advisor recommendations are automatically implemented.
B. Individual SQL Access Advisor recommendations can be scheduled for implementation.
C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D. SQL Access Advisor recommendations are automatically scheduled for implementation during the
maintenance window.
E. None of the above.
。
。
。
。
。
。
。
http://www.oracle-base.com/articles/11g/SQLAccessAdvisor_11gR1.php:The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and
materialized views which might improve system performance. Oracle 11g has made two significant
changes to the SQL Access Advisor:
1. The advisor now includes advice on partitioning schemes that may improve performance.
2. The original workload manipulation has been deprecated and replaced by SQL tuning sets.
10g中主要关于增加索引和物化视图
11g中有2个重要改变: 1. 分区对象 2.10g的功能被弃用,被优化集代替
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
0 0
- 053-16 Which statement most accurately describes the implementation of a SQL Access Advisor recommen
- 16 Which statement most accurately describes the implementation of a SQL Access Advisor recommendati
- A-8 8 Which of these appropriately describes the results of a manual SQL Tuning Advisor task? A. A l
- 053-14 You have a very large table that your users access frequently. Which of the following advisor
- Which statement describes the significance of the CHANGE FAILURE command in RMAN?
- 053-9 To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?
- 053-5 You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan
- 9 To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take? A. From
- Question 48: In C++, which of the following statements accurately describe a base class destructor calling a virtual function ov
- Which statement is true about loading data using the conventional path of SQL*Loader? A.Redo is not
- 173.Which statement describes the effect on an index, when the indexed column for the rows is update
- 37 In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply
- 2 Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)
- 131 Which three functions are performed by the SQL Tuning Advisor? (Choose three.) A. Building the S
- 89.Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Ch
- Share a peice of movie script from Rocky Ⅵ which I love the most.
- Question 28: Which of the following statements accurately describe the new[] operator in C++?
- 67.The instance abnormally terminates because of a power outage. Which statement is true about redo
- Arduino通过HTTP上传Json数据,树莓派再GET回数据
- 33.单例对象
- C语言模块化程序设计概念理解
- 如何将一个浮点型转化为字符串型
- 3d游戏中剧情开启扭转镜头的实现
- 053-16 Which statement most accurately describes the implementation of a SQL Access Advisor recommen
- SuperMap iClient 7C for Flash 开发之线编辑
- 可视化zookeeper的事务日志
- 关于Raphael开发过程中的一些总结
- 递归创建并输出链表
- 1018. 锤子剪刀布 (20)
- eclipse生成可执行jar包
- 前端css规范
- Xshell如何更改文件保存位置