nerdexam
Oracle

1Z0-074 · Question #93

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

The correct answer is 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. Explanation/Reference:

Administering a Multitenant Container Database

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

(33 responses)
  • A
    3% (1)
  • B
    79% (26)
  • C
    3% (1)
  • E
    6% (2)
  • F
    9% (3)

Explanation

Explanation/Reference:

Topics

#single-row functions#function nesting#SQL functions#argument types

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice