Oracle
1Z0-144 · Question #25
Which two statements correctly differentiate functions and procedures? (Choose two.)
The correct answer is B. A function must return a value to the calling environment, whereas a procedure can return zero or C. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure. See the full explanation below for the reasoning.
Question
Which two statements correctly differentiate functions and procedures? (Choose two.)
Options
- AA function can be called only as part of a SQL statement, whereas a procedure can be called only
- BA function must return a value to the calling environment, whereas a procedure can return zero or
- CA function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure
- DA function may return one or more values to the calling environment, whereas a procedure must
How the community answered
(67 responses)- A15% (10)
- B79% (53)
- D6% (4)
Community Discussion
No community discussion yet for this question.