adspace


Define transaction atomicity?

Answer Posted / Avinash Tripathi

Transaction Atomicity refers to a property of a database transaction that ensures that the transaction is treated as a single, indivisible unit. This means that all operations within the transaction must either be completed successfully or rolled back to their original state in case of any failure.nnIn other words, atomic transactions guarantee the following properties:n
1. Consistency: The database remains in a valid state before and after the transaction is executed.
2. Isolation: Concurrent transactions do not interfere with each other's data access or modifications.
3. Durability: Once committed, the changes made by the transaction persist even if there's a system failure.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category