Interested to Buy Any Domain ? << Click Here >> for more details...
5 rows are inserted to a DB2 Table. Next 3 of those are
updated, then a rollback is issued. What would happen when
the rollback is issued?
- 2 Answers
- 6344 Views
- I also Faced
- E-Mail Answers
Answer Posted / rashmi
The 5 inserted records will not be there in the table.
Becouse rollback is happening before the commit(Untill
unless you commit it, the changes will not reflect in the
table).
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Explain about open switch business continuity software?
Explain the contention situations caused by locks?
What is the purpose of rollback and commit?
How to create db2 table in mainframe?
What is ibm db2 client?
How can deadlocks be resolved?
What is scrollable cursor in db2?
Define predicate?
What is db2 instance?
Explain about rct in db2?
What are the different types of base tables?
What is explain in db2?
What kind of database is db2?
What is the max length of sqlca?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
