Multiple choice technology databases

Primary difference between a stored procedure and stored function is that, function must return a value through an explicit return statement wherein stored procedure does NOT.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Functions must return a value using an explicit RETURN statement in SQL. Stored procedures can modify data and return values through OUT parameters, but they are not required to return a value. This is a fundamental distinction in database programming.