What is a transaction and what are ACID properties?
Answer Posted / sonu
A transaction is a sequence of sql Operations,
work as single atomic unit of work. To be qualify
as a "Transaction" , this sequence of operations must satisfy 4 properties , which is knwon as ACID test.any database must follow these acid properties.
Atomicity:-The sequence of operations must be atomic,
either all or no operations are performed.
Consistency:- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.
Isolation: A Transaction must be isolated from all other
transactions. A transaction sees the data before the
operations are performed , or after all the operations has
performed, it can't see the data in between.
Durability: All oprtaions must be permanently placed on
the system. Even in the event of system failure , all the
operations must be exhibit.
Is This Answer Correct ? | 7 Yes | 10 No |
Post New Answer View All Answers
What does asynchronous call backs means?
what are the important architecture components of SSRS?
What are the Advantages of using CTE in sql server?
What is 2nf normalization form?
can a database be shrunk with users active? : Sql server administration
How to execute the cursor queries with "open" statements?
What is exporting utility?
What are the recovery models in sql server 2000?
In which tcp/ip port does sql server run? Can it be changed?
What is an sql server agent?
What stored by the msdb?
How to rename an existing column with sql server management studio?
What is the difference between count and distinct count?
What is hot add cpu in sql server 2008?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration