05th
May
Stored procedures Interview questions

Interview questions on stored procedures

  • Aarush Shukla
  • 05th May, 2021
  • 754 Followers

About Stored Procedure

The stored procedure is a subroutine of SQL language which can be used and reused for repeated access of elements of data from the database management system. The main uses of stored procedures are data validation, access control mechanisms.Developers use the Stored Procedure to save time, memory and complex processing which needs extensive SQL statements repeatedly. The frequently used SQL statements are accumulated in the Stored Procedure and applications needing them can call the procedures. The most important part of the Stored Procedure is the parameter. Parameters are used to pass values to the procedures for operation. They are mainly of 3 types IN, OUT, INOUT.

Stored procedures Interview questions

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.