Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78529 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 are different types of collation sensitivity?
What is the difference between Stored Procedures and triggers?
What does normalization do to data?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Explain DBCC?
What is data compression? : sql server database administration
Do you know what is difference between index seek vs. Index scan?
Explain how many normalization forms?
What is cursors?
What is store procedure? How do they work? When do you use?
How do I schedule a sql server profiler trace?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Explain indexing and what are the advantages of it?
What is the difference between varchar and nvarchar datatypes?
