Database Developer Question:
Download Questions PDF

Explain me what is Stored procedure?

Answer:

A Stored Procedure is a collection of SQL statements that have been created and stored in the database to perform a particular task. The stored procedure accepts input parameters and processes them and returns a single value such as a number or text value or a result set (set of rows).

Download Database Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me how to avoid duplicate records in a query?Tell us what are the different DML commands in SQL?