Oracle Database 11g: SQL Fundamentals I — Question 15

Which two statements are true regarding single row functions? (Choose two.)

Answer options

• A. They can be nested only to two levels.
• B. They always return a single result row for every row of a queried table.
• C. Arguments can only be column values or constant.
• D. They can return a data type value different from the one that is referenced.
• E. They accept only a single argument.

Correct answer: B, D

Explanation

The correct answers are B and D. Option B is accurate because single row functions indeed return one result for each row in the table. Option D is also correct since these functions can return different data types than those of the input. Options A, C, and E are incorrect as they misrepresent the capabilities and flexibility of single row functions.