Stored Procedure Question:
Download Job Interview Questions and Answers 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 Question | Next Question |
| Explain about the implementation of business logic in Stored procedures? | Explain about recursive stored procedures? |