Which of the following is an advantage of stored procedures?
A) Data integrity improves when fewer applications access the procedure.
B) The layers get cleaner.
C) Stored procedures result in fatter clients.
D) Performance improves for compiled SQL statements.

Question

Quizplus · Accepted Answer

Stored procedures can improve performance for compiled SQL statements because they are precompiled and stored in memory, reducing the need for recompiling and parsing SQL statements each time they are executed. This can result in faster execution times for complex queries and can reduce network traffic. A, B, and C are not advantages of stored procedures.

Which of the Following Is an Advantage of Stored Procedures