Differences between stored procedures

1. Which of the following stored procedures can be used to accept input parameters and return multiple values in the form of output parameters to the calling procedure or batch?

2. Which of the following stored procedures can contain programming statements that perform operations in the database, including calling other procedures?

3. Which of the following stored procedures can return a status value to a calling procedure or batch to indicate success or failure (and the reason for failure)?