Stored Procedure Question:

Download Job Interview Questions and Answers PDF

What are the uses of stored procedure?

Stored Procedure Interview Question
Stored Procedure Interview Question

Answer:

Stored procedures are often used for data validation and as access control mechanism. Logic applied in applications can be centralized and stored in applications. Complex procedures and functionalities which require huge amount of data processing and logic implementation access their data by procedures. Data is stored in these procedures and accessed by procedures.

Download Stored Procedure Interview Questions And Answers PDF

Previous QuestionNext Question
What is a stored procedure?What is the difference between a user defined function and a Stored procedure?