ocp-410
来源:互联网 发布:软件杂志投稿 编辑:程序博客网 时间:2024/04/27 17:26
QUESTION NO: 410?
You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS(‘SH’, ‘CUSTOMERS’, ‘PUBLISH’,’false’);
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(‘SH’, ‘CUSTOMERS’);
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the
above session?
A. The statistics are stored in the pending statistics table in the data dictionary.
B. The statistics are treated as the current statistics by the optimizer for all sessions.
C. The statistics are treated as the current statistics by the optimizer for the current sessions only.
D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
Answer: A
在以上会话中,有关在SH.客户表的上述统计集上,哪种说法是正确的?
A.统计信息存储在数据字典中的挂起的统计表。
- ocp-410
- ocp
- ocp
- OCP
- Ocp
- OCP
- ocp
- OCP
- ocp
- OCP考试
- OCP原则
- OCP题
- OCP构想
- OCP考试
- OCP原则
- oracle ocp
- 转载OCP
- 转载 OCP
- JAVA关于静态变量的初始化需要注意的点
- windows 网络基本问题
- ocp-409
- [转]Android客户端和服务端如何使用Token和Session
- enum枚举类型使用
- ocp-410
- ScrollView 和 GridView冲突和ViewPager冲突解决和ListView冲突解决
- 总显示Picked up JAVA_TOOL_OPTIONS: -javaagent:/usr/share/java/jayatanaag.jar解决办法
- ocp-411
- Android广告位
- 关于URL编码
- vs 下 apache 模块 调试
- 从零使用qemu模拟器搭建arm运行环境
- mongodb数组与内嵌文档查询