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.
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



Leave a Reply 1

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


Hola

Hola

Manipulate data items
Act on each row returned
Return one result per row
Accept arguments that can be a column or expression