Oracle
1Z0-082 · Question #76
Which three statements are true about single-row functions? (Choose three.)
The correct answer is 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 F. They return a single result row per table. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which three statements are true about single-row functions? (Choose three.)
Options
- AThey can be used only in the WHERE clause of a SELECT statement
- BThe argument can be a column name, variable, literal or an expression
- CThe data type returned can be different from the data type of the argument
- DThey can be nested to any level
- EThey can accept only one argument
- FThey return a single result row per table
How the community answered
(38 responses)- A8% (3)
- B74% (28)
- D16% (6)
- E3% (1)
Topics
#single-row functions#function arguments#data type conversion#function nesting
Community Discussion
No community discussion yet for this question.