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 |
What is the role of union all and union
how can u nderstand the sql stmts executed successfully or not ?
What is ACQUIRE/RELEASE in BIND?
How do you do the EXPLAIN of a dynamic SQL statement?
What is the difference between Primary key and unique index?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
Explain the benefits you can get from mainframe connect?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What r the comman abends in db2, jcl and cobol???????
What is buffrpool? Where we use it ?
Define db2 and its databases?
What is reorg and runstats in db2?