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
- 6134 Views
- I also Faced
- E-Mail Answers
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 query_cache_limit?
What is tablespace?
Can any one tell me about Restart logic in DB2.
What should be specified along with a cursor in order to continue updating process after commit?
What is a cursor?
Which isolation level provides maximum concurrency?
i want to maintain uniqueness on pdf without make lf??????????
What is the difference between nvl and coalesce?
What is bind in db2?
Explain the use of the WHERE clause.
Can we update view in db2?
What information is contained in a SYSCOPY entry?
COBOL 
