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
- 6254 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 |
can all users have the privilage to use the sql statement select * (dml)?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
How many buffer pools are available in db2?
What is host variable in db2 cobol?
What is a system catalog table in db2?
How can deadlocks be resolved?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
why we create view.
List some fields from sqlca?
how can u retrieve the data from null values using applicaion program.
What is the role of union all and union
What is a clustering index?
COBOL 
