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?
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
What is cursor stability in db2?
What is a collection in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
How many databases are there?
Are views updateable?
What is bind in db2?
What is bind and rebind in db2?
Is db2 a mainframe database?
Why do chiropractors use drop table?
Define check constraint.
What os does db2 run on?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Why select is not preferred in embedded sql programs?
What is the difference between oracle and db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?