Oracle
1Z0-047 · Question #74
Which three statements are true regarding single-row functions? (Choose three.)
The correct answer is D. They can be used in SELECT, WHERE, and ORDER BY clauses. E. They return data type can be different from the data type of the argument that is referenced. F. They can accept a column name, expression, variable name, or a user-supplied constant as arguments. See the full explanation below for the reasoning.
Question
Which three statements are true regarding single-row functions? (Choose three.)
Options
- AThey can accept only one argument.
- BThey can be nested up to only two levels.
- CThey can return multiple values of more than one data type.
- DThey can be used in SELECT, WHERE, and ORDER BY clauses.
- EThey return data type can be different from the data type of the argument that is referenced.
- FThey can accept a column name, expression, variable name, or a user-supplied constant as arguments.
How the community answered
(47 responses)- A2% (1)
- B9% (4)
- C15% (7)
- D74% (35)
Community Discussion
No community discussion yet for this question.