Stored procedures Interview questions For Freshers & Experienced

  • Sharad Jaiswal
  • 28th Dec, 2019
  • 336 Followers

Stored procedures Interview questions
Updated ON

28th Dec, 2019

No. of Questions

0

Posted In

Database

Author

Sharad Jaiswal

What are Stored Procedures?

A group of SQL statements placed together forms a Stored Procedure. A Stored Procedure is created as well as stored in a database. It accepts input parameters to ensure that a single procedure can be used by some clients using different input data over the network. There are several reasons why a stored procedure is in use. It allows modular programming, faster execution, can reduce network traffic, and also does provide better security to the stored data. If a stored procedure is modified the clients receive the updated stored procedure.

Key Features of Stored Procedures

Below are few major features of Stored Procedures

Maintainability

Optimized Speed

Isolation of Business Rules

Iterative Loops and Conditions

Precompiled

Scalability and Interoperability

About Author :

  • Author of Stored procedures Interview questions

    Sharad Jaiswal

    Sharad Jaiswal is Sr. Web Developer from Noida area. He have rich experience in PHP, Angular Js, React, javascript and Node .If you any query or project on these programming you can drop your enquiry in comment section.

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.