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:
A:
is not single row attributes
E:
functions can accept more than one argument, e.g NVL2
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 3-5
Manipulate data items
Act on each row returned
Return one result per row
Accept arguments that can be a column or expression