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 'Bny mellon' - 1 question(s) found - Order By Newest|
|Ans. When a DML is executed, the changes only stays in session and still not pushed to DB Tables, Commit is used to push those changes to the Tables. |
In case we realize that we don't want to commit those changes and would like to ignore them, we can use rollback.
For example - You may like that for a banking transaction you would like to update the account balance only if the debit or credit record was correctly inserted, so you may like to encapsulate both DML's - insert for transaction and update for balance in a single transaction and would only commit if both succeeds else rollback.
|Help us improve. Please let us know the company, where you were asked this question :|
|Like Discuss Correct / Improve  databases  commit  rollback Asked in 2 Companies Basic|
|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 ACID ?|
|What is the use of @GeneratedValue annotation in Hibernate?|
|What happens to backups if we delete the RDS instance ?|
|What is a Cursor ?|
|What are temp tables ?|
|Does SQL allow null values ? Can we use it within Where clause ?|
|Write an SQL to find all records having all upper case alphanumeric characters in a field ?|