Database Fundamentals — Question 36

One difference between a function and a stored procedure is that a function:

Answer options

• A. Must be called from a trigger.
• B. Must return a value.
• C. Cannot contain a transaction.
• D. Cannot accept parameters.

Correct answer: B

Explanation

The correct answer is B because functions are designed to return a single value, whereas stored procedures do not have this requirement. Options A, C, and D are incorrect as they do not accurately reflect the characteristics of functions in relation to stored procedures.