Stored Procedure Interview Questions

 
1.
What is a stored procedure?
2.
What are the uses of stored procedure?
3.
What is the difference between a user defined function and a Stored procedure?
4.
Explain about the implementation of stored procedures?
5.
State the different extensions for stored procedures?
6.
State about the security aspects of stored procedures?
7.
Does storing of data in stored procedures increase the access time? Explain?
8.
Explain about the difficulties faced by the database developer in implementing pre compiled statements?
9.
Explain about the implementation of business logic in Stored procedures?
10.
Explain the benefits of running stored procedure on a database engine?
11.
Explain about recursive stored procedures?
12.
Explain about the process which takes place to execute a Stored routine?
13.
Explain about the RETURN statement?
14.
Explain about cursors?
15.
Explain about the properties of Cursors?
16.
How do you notify DBPAK about Stored Procedure?
17.
Explain about the case statement present in Stored procedure?