What is a transaction and what are ACID properties?
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 the difference between ddl,dml and dcl commands?
What is scheduled job and how to create it?
What is user-defined function?
If no size is defined while creating the database, what size will the database have?
How to delete duplicate records based on single column from a table?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
why would you use sql agent? : Sql server database administration
Can you create a logon trigger in sql server 2005 express edition?
In what sequence sql statement is processed?
How many types of stored procedures are there in sql server?
What is index, cluster index and nonclustered index?
Where are sql server user names and passwords stored in sql server?
How to include date and time values in sql statements?
Is t sql the same as sql server?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?