Which four are attributes of single row functions?

Which four are attributes of single row functions? (Choose four.)

Which four are attributes of single row functions? (Choose four.)

A.
accept only one argument and return only one value

B.
cannot be nested

C.
manipulate data items

D.
act on each row returned

E.
return one result per row

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
* functions can accept more than one argument, e.g NVL2
Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 3-5



Leave a Reply 1

Your email address will not be published. Required fields are marked *