Hameed

• Oct 30th, 2005

 

In critical applications dealing with data ,the application has to ensure that the logical work done on the data leaves it in a consistent state .Tranascations are required to ensure that either the data is completely modified or if some problem occurs midway through then everything is brought back to the original state .Transactions ensure this ...

kedar

• Jan 7th, 2006

 

Transactions ensure that database actions are consistent. Consider a case where a record is required to be added to say two databases simultaneaously. If the record is added to both the databases, action is consistent & transaction is complete but if the record is not added to one of the databases, then the action of "Add" record is rolled back across both the databases for this record, making records in both the databases consistent. Transactions ensure atomic nature of database action.

dharmendracg

 Profile Answers by dharmendracg 

• Jan 15th, 2006

 

Txns is a unit of work which guaranties about it's execution.