sanjaykp

 Profile Answers by sanjaykp 

• Mar 12th, 2010

 

To guarantee the authenticity and integrity of any change to data in a database(s), be it an insert, update or delete. Transactions are a fundamental tool used by all industry standard Relation Database systems, and can be also used in a non-database oriented environment. The key to a transaction is the acronym ACID. Authenticity, Consistency, Integrity and Durability.

kirangiet

 Profile Answers by kirangiet 

• Aug 16th, 2010

 

SQL Transactions ensure to follow ACID Properties.

A-Atomicity: Using Transactions, either none or all the statements inside the transaction will execute successfully.

C-Consistency: Using Transaction, we can ensure that, using the SQL statement we moved the table/tables from one consistent state to another. 

I-Isolation: By using Isolation levels along with transactions, we can ensure that no other SQL statement is using the table while transaction is in progress.

D-Durability: No data should be lost. One good thing with Transactions are we can roll back if we feel there is some problem with the query. However we have logs from where we can restore our data.