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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
The 5 rows inserted will be not be present in the table.
| Is This Answer Correct ? | 5 Yes | 0 No |
How do you stop a db2 database in linux?
Differentiate between cs and rr isolation levels? Where do you specify them?
what is a collection?
How do you eliminate duplicate values in db2?
On which levels locks can be applied?
What is isolation level in db2?
what is a trigger and types of triggers
Explain db2.
What happens to a cursor after a commit?
what are bind concepts in db2 cobol?
How do I add a column in db2?
What are the 2 sqlcodes that are returned?