you typically use the return value of a stored procedure to indicate to the calling program whether the stored procedure completed successfully. Thus correct option( b).
Between the user interface and the database, a stored procedure adds an important layer of security. Because end users can enter or change data but not write procedures, it promotes security through data access controls.
What exactly is a stored procedure?
A stored procedure is a prepared SQL code that can be saved and reused multiple times. So, if you have a SQL query that you write repeatedly, save it as a stored procedure and simply call it to execute it.
Stored Procedure Types
Learn more about stored procedure to visit this link
https://brainly.com/question/29577376
#SPJ4
Full Question:You typically use the return value of a stored procedure to
-return an output parameter to the calling program
- indicate to the calling program whether the stored procedure completed successfully
- receive an input parameter from the calling program
- return a zero value
