4. Which two statements are true regarding single row functions? (Choose two.)
A. They a ccept only a single argument.
B. They c an be nested only to two levels.
C. Arguments can only be column values or constants.
D. They a lways return a single result row for every row of a queried table.
E. They c an return a data type value different from the one that is referenced.
Answer: DE
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12848395
A. 只接受一个参数,错误,可以接受一个或多个参数
B. 只可以被嵌套两级,错误,可以被全套多级
C. 参数只能是列值或者常量.,参数还可以是变量和表达式
D. 对于查询表的每一行总是返回一个结果行.正确。
E. 返回的数据类型值可以与之前引用的数据类型不同,正确。