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
- 6208 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 the picture clause of the null indicator variable?
wht displays the number of times a query modified ?
Explain various types of locks in db2?
What does it mean if the null indicator has -1, 0, -2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the role of data manager in the db2 database?
What is normalization and what are the five normal forms?
What is the difference between CS and RR isolation levels?
What will the FREE command do to a plan?
Mention data types used in db2 ?
what are extents?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
COBOL 
