Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answers were Sorted based on User's Feedback



5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What ..

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

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What ..

Answer / guest

The 5 rows inserted will be not be present in the table.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

List out the data types available.

0 Answers  


What are union and union all?

0 Answers  


What is the SQL Communications Area and what are some of its key fields?

1 Answers  


how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


how to resolve -811 error. give clear explination

4 Answers   IBM,


What is cursor stability in db2?

0 Answers  


What is check constraint. Explain with example.

0 Answers  


When is the skeleton cursor table created?

1 Answers  


i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


Why do we use cursor?

0 Answers  


What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,


Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  


Categories