Multiple choice technology

Which two statements are true regarding single row functions?

  1. They accept only a single argument.

  2. .They can be nested only to two levels.

  3. Arguments can only be column values or constants.

  4. They always return a single result row for every row of a queried table.

  5. They can return a data type value different from the one that is referenced.
Reveal answer Fill a bubble to check yourself
D,E Correct answer
Explanation

Single-row functions operate on each row independently and return exactly one result per input row (option D). They can return data types different from their input arguments - for example, TO_CHAR converts numbers to strings, and NVL can return different types based on its first argument (option E). Options A, B, and C are false: single-row functions accept multiple arguments (like SUBSTR), can be nested deeply beyond two levels, and accept expressions, not just column values or constants.

Keep practicing — related questions