Oracle
1Z0-071 · Question #154
Which three statements are true regarding single-row functions? (Choose three.)
The correct answer is A. The data type returned, can be different from the data type of the argument that is referenced. E. They can be used in SELECT, WHERE, and ORDER BY clauses. F. They can accept column names, expressions, variable names, or a user-supplied constants as. See the full explanation below for the reasoning.
Question
Which three statements are true regarding single-row functions? (Choose three.)
Options
- AThe data type returned, can be different from the data type of the argument that is referenced.
- BThey can return multiple values of more than one data type.
- CThey can accept only one argument.
- DThey can be nested up to only two levels.
- EThey can be used in SELECT, WHERE, and ORDER BY clauses.
- FThey can accept column names, expressions, variable names, or a user-supplied constants as
How the community answered
(15 responses)- A80% (12)
- B13% (2)
- D7% (1)
Community Discussion
No community discussion yet for this question.