Oracle Database SQL — Question 245

Which three statements are true about single-row functions? (Choose three.)

Answer options

• A. They return a single result row per table.
• B. They can be nested to any level.
• C. They can accept only one argument.
• D. The argument can be a column name, variable, literal or an expression.
• E. They can be used only in the WHERE clause of a SELECT statement.
• F. The data type returned can be different from the data type of the argument.

Correct answer: B, D, F

Explanation

The correct answers are B, D, and F. Single-row functions can indeed be nested to any level (B), accept various types of arguments (D), and return a different data type than what was provided (F). However, A is incorrect because these functions do not return a result row per table, C is wrong as they can accept multiple arguments, and E is false since they can be used in more contexts than just the WHERE clause.