Question

Point out the correct statement.

(a) Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed

(b) A stored procedure is a group of Transact-SQL statements pre compiled into a single execution plan

(c) Stored procedures cannot improve performance

(d) All of the mentioned

I got this question in unit test.

This interesting question is from Stored Procedure topic in portion Developing with SQL Server of SQL Server

Answer 1

The correct answer is (a) Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed

Easy explanation: Stored procedures assist in achieving consistent implementation of logic across applications.