Database - Interview Questions and Answers for 'Stored procedure' | Search Interview Question - javasearch.buggybread.com
Javasearch.buggybread.com

Search Interview Questions


 More than 3000 questions in repository.
 There are more than 900 unanswered questions.
Click here and help us by providing the answer.
 Have a video suggestion.
Click Correct / Improve and please let us know.
Label / Company      Label / Company / Text

   



Database - Interview Questions and Answers for 'Stored procedure' - 2 question(s) found - Order By Newest

 Q1. What is a Database Procedure ?Database
Ans. Stored procedures are a batch of SQL statements along with programming constructs ( if else, loops etc ) and stored as a single program that can be called by different clients and hence reused.


 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     database  stored procedure     Asked in 2 Companies      basic        frequent


Related Questions

 What is ACID ?
  What is database deadlock ? How can we avoid them?
  What things you would care about to improve the performance of Application if its identified that its DB communication that needs to be improved ?
  If you are given a choice to implement the code to either Insert a Record or Update if already exist, Which approach will you follow ?
  What is the use of @GeneratedValue annotation in Hibernate?
  What are temp tables ?
 What is a Database Trigger ?
 What is database Normalization ?
 What happens to backups if we delete the RDS instance ?
  What is a Cursor ?


 Q2. How should we handle errors while writing or accessing Stored Procedures?Database
Ans. Store Procedure returns the error code. Moreover we can put the call withing try block and catch SQL Exception.

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     stored procedure  exception handling


Related Questions

 What is a Database Procedure ?
 Where does database stored procedures gets stored ?



Help us and Others Improve. Please let us know the questions asked in any of your previous interview.

Any input from you will be highly appreciated and It will unlock the application for 10 more requests.

Company Name:
Questions Asked: