Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78018 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 do you mean by subquery?
How to use union to merge outputs from two queries together in ms sql server?
What is mapping schema?
How can you control the amount of free space in your index pages?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is the need for indexing?
What is update locks?
How many servers can we create in a single subscription?
What is the dbcc command and why is it used?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is the difference between a function and a trigger?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Explain optimistic and pessimistic concurrency?
What is thr feature of change data capture?
