Which four are attributes of single row functions? (Choose four.)
A.
cannot be nested
B.
manipulate data items
C.
act on each row returned
D.
return one result per row
E.
accept only one argument and return only one value
F.
accept arguments which can be a column or an expression
Explanation:
manipulate data items, act on each row returned, return one result per row, and accept arguments
that can be a column or expression.
Incorrect answer:
Ais not single row attributes
Efunctions can accept more than one argument, e.g NVL2
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 3-5