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. |
|
|||
|
| ||||
| Database - Interview Questions and Answers for 'Stored procedure' - 2 question(s) found - Order By Newest | ||||
| ||||
| 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 : | ||||
 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 ? | ||||
| ||||
| 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 : | ||||
| Discuss Correct / Improve stored procedure exception handling | ||||
| Related Questions | ||||
| What is a Database Procedure ? | ||||
| Where does database stored procedures gets stored ? | ||||
