nerdexam
Oracle

1Z0-071 · Question #365

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

The correct answer is A. They can be nested to any level B. The data type returned can be different from the data type of the argument D. The argument can be a column name, variable, literal or an expression. See the full explanation below for the reasoning.

Question

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

Options

  • AThey can be nested to any level
  • BThe data type returned can be different from the data type of the argument
  • CThey can accept only one argument
  • DThe argument can be a column name, variable, literal or an expression
  • EThey can be used only in the WHERE clause of a SELECT statement
  • FThey return a single result row per table

How the community answered

(21 responses)
  • A
    81% (17)
  • C
    5% (1)
  • E
    5% (1)
  • F
    10% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice