Stored procedures have the advantage of greater security,decreased network traffic,SQL optimized by the DBMS compiler,and code sharing.

Question

Quizplus · Accepted Answer

Stored procedures can improve security as they limit direct access to the database and can be set up with restricted permissions. They also reduce network traffic by allowing multiple database operations to be executed with a single procedure call. The code of a stored procedure is compiled by the DBMS, which can optimize the SQL statements included. Finally, stored procedures encourage code sharing as they can be called by multiple applications or users, reducing the need for duplicate code.

Stored Procedures Have the Advantage of Greater Security,decreased Network Traffic,SQL