What is a transaction and what are ACID properties?
- 14 Answers
- 75002 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / pravesh
A transaction is a sequence of sql Operations(commands),
work as single atomic unit of work. To be qualify
as "Transaction" , this sequence of operations must satisfy
4 properties , which is knwon as ACID test.
A(Atomicity):-The sequence of operations must be atomic,
either all or no operations are performed.
C(Consistency):- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.
I(Isolation): A Transaction must be isolated from all other
transactions. A transaction sees the data defore the
operations are performed , or after all the operations has
performed, it can't see the data in between.
D(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 ? | 309 Yes | 26 No |
Post New Answer View All Answers
Explain foreign key in sql server?
Why should we go for stored procedures? Why not direct queries?
how many clustered indexes can be created on a table? : Sql server database administration
Tell me something about security and sql azure?
What is the difference between osql and query analyzer?
What is a cursor, index in sql?
What are the types of indexes?
How do you check sql server is up and running?
What is data block and how to define data block size?
What is the use of toad or sqldbx.?
How to list all stored procedures in the current database using ms sql server?
What is dknf in normalization form?
Who developed sql server?
What is a periodical index?
What is history table in sql server?
