152.Which statement is true regarding the UNION operator?
来源:互联网 发布:智阳网络 金融 编辑:程序博客网 时间:2024/04/27 19:02
152.Which statement is true regarding the UNION operator?
A.By default, the output is not sorted.
B.NULL values are not ignored during duplicate checking.
C.Names of all columns must be identical across all SELECT statements.
D.The number of columns selected in all SELECT statements need not be the same.
答案:B
解析:union就是合并,排除重复数据,不会忽略null,会排序(由于会滤重,所以会排序),合并的查询列数需要相等,类型必须相等或者隐式转换,
不支持long类型
A.By default, the output is not sorted.
B.NULL values are not ignored during duplicate checking.
C.Names of all columns must be identical across all SELECT statements.
D.The number of columns selected in all SELECT statements need not be the same.
答案:B
解析:union就是合并,排除重复数据,不会忽略null,会排序(由于会滤重,所以会排序),合并的查询列数需要相等,类型必须相等或者隐式转换,
不支持long类型
0 0
- 152.Which statement is true regarding the UNION operator?
- 9.Which statement is true regarding the INTERSECT operator?
- 1Z0-051 9.Which statement is true regarding the INTERSECT operator?
- 98.Which statement is true regarding the COALESCE function?
- 51.Which statement is true regarding synonyms?
- 138.Which statement is true regarding subqueries?
- 68.Which statement is true regarding the default behavior of the ORDER BY clause?
- 4.Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of
- 174.Which statement is true regarding transactions? (Choose all that apply.)
- 117.Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
- 158.Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all tha
- 31.Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enable
- 45.Which statement is true about the Manageability Monitor (MMON) background process?
- 67.The instance abnormally terminates because of a power outage. Which statement is true about redo
- 97.Which statement is true about loading data using the conventional path of SQL*Loader?
- 86.View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true
- 160.View the Exhibit to observe the roles assigned to the SLP_REP user. Which statement is true a
- 166.View the Exhibit and examine the setting for a table. Which statement is true about the PCTFR
- Android中UDP通信
- Win7+QtCreater3.5.1+Qt4.8.7+Mingw+gdb
- Linux valgrind 部署安装
- 进程和线程的区别
- stiB1forebmuN.191
- 152.Which statement is true regarding the UNION operator?
- Hbase使用filter快速高效查询
- PAT (Basic Level)1038. 统计同成绩学生
- 学习Aandroid开发工具之一
- 交大1042,公共字符串,动态规划
- Java:单例模式的七种写法
- Genymotion问题一 Unable to start the virtual device
- static inline和extern inline辨析
- 节省苹果手机电源,优化APP耗电