Stored Procedure Question:
Download Questions PDF

Explain the benefits of running stored procedure on a database engine?

Answer:

Stored procedures can run directly run on a data base engine. In industries where automation is the key a stored procedure can run entirely on the data base provided to it and this runs on a specialized data base server. Network communication can be avoided. Also this procedure is useful for execution of complex SQL statements.

Download Stored Procedure Interview Questions And Answers PDF

Previous QuestionNext Question
Explain about the implementation of business logic in Stored procedures?Explain about recursive stored procedures?