What is a transaction and what are ACID properties?
Answer Posted / mobin sathupally
A transaction is a logical unit of work in which, all the
steps must be performed or none.A transaction follows four
properties(rules).These four properties are known as ACID.
ACID stands for Automocity,Consistency,Isolation and
Durability.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to drop existing views from a database in ms sql server?
Where in ms sql server is ’100’ equal to ‘0’?
Can you explain various data region available in ssrs with their use?
What is an indice?
How do you troubleshoot errors in a SQL Server Agent Job?
Explain filtered indexes benefits?
What is for xml in sql server?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Why is replication required on the sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
Differentiate between ms sql server reporting services vs crystal reports?
Can you name some of the dml commands in sql?
What is the difference between nvl and nvl2?
What is the filtered index?
What is enhanced database mirroring in sql server 2008?