Question

Data return using output parameter is ____________

(a) Return codes, which are always an integer value

(b) A global cursor that can be referenced outside the stored procedure

(c) A single cursor that can be referenced inside the stored procedure

(d) None of the mentioned

This question was addressed to me during an interview.

Question is taken from Stored Procedure in section Developing with SQL Server of SQL Server

Answer 1

Correct option is (d) None of the mentioned

The best explanation: Output parameters, which can return either data (such as an integer or character value) or a cursor variable (cursors are result sets that can be retrieved one row at a time).