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...


There are six records in a file and we are going to update
that records and used commit operation when it complete the
update but suppose when it updating the third record,a
error occured and operation failed.Is previously two
records will be update or whole operation will be rollback?
Please confirm it.

Answers were Sorted based on User's Feedback



There are six records in a file and we are going to update that records and used commit operation ..

Answer / sandy

Whole operation will be rolled back.

Is This Answer Correct ?    11 Yes 0 No

There are six records in a file and we are going to update that records and used commit operation ..

Answer / nitendra

Whole operation will be rolled back.
A commit operation guarantees that the group of operations
is completed. A rollback operation guarantees that the
group of operations is backed out.

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More DB400 Interview Questions

what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,


what is the purpus of the chain and setll and setgt ?

2 Answers   Four soft,


What is the interactive job? What is the batch job? How to change the batch job to interactive job?

0 Answers  


A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  


Define interactive jobs and batch jobs

6 Answers  


How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,


Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,


can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,


What is the interactive job? What is the batch job?

0 Answers  


how to update physical files using normal logical file

4 Answers  


Why we create the Physical File Member?

5 Answers  


Why journalling is compulsory before commitment control?

1 Answers  


Categories