Oracle Database Administration I — Question 1

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

Answer options

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

Correct answer: B, C, D

Explanation

Options B, C, and D are correct because single-row functions can accept various types of inputs, return different data types, and can be nested to any level. Option A is incorrect as these functions can be used in multiple places, not just in the WHERE clause. Option E is wrong because they can accept multiple arguments in some cases, and F is misleading since they return a single result row per input, not per table.