OCP-1Z0-051-V9.02-4题

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. 返回的数据类型值可以与之前引用的数据类型不同,正确。

原文地址:https://www.cnblogs.com/hzcya1995/p/13316822.html