Stored Procedure Question:

Download Job Interview Questions and Answers PDF

Explain about the implementation of business logic in Stored procedures?

Stored Procedure Interview Question
Stored Procedure Interview Question

Answer:

Stored procedures implement business logic into the database. It is embedded as API and this reduces the implementation of Logic code again explicitly. Implementation of business logic internally reduces the chances of data becoming corrupt.

Download Stored Procedure Interview Questions And Answers PDF

Previous QuestionNext Question
Explain about the difficulties faced by the database developer in implementing pre compiled statements?Explain the benefits of running stored procedure on a database engine?