98.Which statement is true regarding the COALESCE function?
来源:互联网 发布:怎么加淘宝商家微信号 编辑:程序博客网 时间:2024/04/29 10:08
98.Which statement is true regarding the COALESCE function?
A.It can have a maximum of five expressions in a list.
B.It returns the highest NOT NULL value in the list for all rows.
C.It requires that all expressions in the list must be of the same data type.
D.It requires that at least one of the expressions in the list must have a NOT NULL value.
答案:C
解析:
COALESCE:返回第一个不为null的值,必须至少两个表达式,如果表达式全为null,那么返回null,参数类型必须相等
A.It can have a maximum of five expressions in a list.
B.It returns the highest NOT NULL value in the list for all rows.
C.It requires that all expressions in the list must be of the same data type.
D.It requires that at least one of the expressions in the list must have a NOT NULL value.
答案:C
解析:
COALESCE:返回第一个不为null的值,必须至少两个表达式,如果表达式全为null,那么返回null,参数类型必须相等
0 0
- 98.Which statement is true regarding the COALESCE function?
- 9.Which statement is true regarding the INTERSECT operator?
- 152.Which statement is true regarding the UNION operator?
- 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?
- 1Z0-051 9.Which statement is true regarding the INTERSECT operator?
- 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?
- 108.Which two statements are true regarding the COUNT function? (Choose two.)
- 158.Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all tha
- 98.Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
- 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
- oracle 11g安装教程 win7 64位
- $@
- matlab中如何获取当前日期时间函数
- 软件开发模式对比(瀑布、迭代、螺旋、敏捷)
- Android:30分钟弄明白Touch事件分发机制
- 98.Which statement is true regarding the COALESCE function?
- VMProtect简单教程
- Python学习笔记-列表1
- 桌面虚拟化传输协议之android spice及spice源码分析之server(1)
- numpy.reshape
- 支付宝和微信支付封装
- dpi,dp,dip,px,density区别
- DB2triples的使用
- google map 美国地区麻点图效果