Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78072 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
What is openrowset sql server?
What is a partition key?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What are the different SQL Server Versions you have worked on?
What are the aggregate and scalar functions?
What is compound operators?
What is the difference between update lock and exclusive lock?
What is de-normalization in sql database administration? Give examples?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Where are stored procedures in sql server?
How can we remove orphan records from a table?
What is filestream?
How many types of schemas are there?
What is an indice?
What is Federation Root Database?
