Point out the correct statement :
A. Stored procedures assist in achieving a consistent implementation of logic across applications
B. A stored procedure is a group of Transact-SQL statements compiled into a single execution plan
C. Stored procedures can also improve performance
D. All of the mentioned
Answer:A
Point out the correct statement :
A. Stored procedures assist in achieving a consistent implementation of logic across applications B. A stored procedure is a group of Transact-SQL statements compiled into a single execution plan C. Stored procedures can also improve performance D. All of the mentioned
Explanation:The SQL statements and logic needed to perform a commonly performed task can be designed, coded, and tested once in a stored procedure.