SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
Do you know what are ACID properties of Transaction?
Answer:
Following are the ACID properties for Database.
Atomicity – Transactions may be set of SQL statements. If any of statement fails then the entire transaction fails. The transaction follows all or nothing rule.
Consistency – This property says that the transaction should be always in consistent state. If any transaction is going to effect the database’s consistent state then the transaction could be rolled back.
Isolation – This property says that one transaction can not retrive the data that has been modified by any other transaction until its completed.
Durability – When any transaction is committed then it must be persisted. In the case of failure only committed transaction will be recovered and uncommitted transaction will be rolled back.
Atomicity – Transactions may be set of SQL statements. If any of statement fails then the entire transaction fails. The transaction follows all or nothing rule.
Consistency – This property says that the transaction should be always in consistent state. If any transaction is going to effect the database’s consistent state then the transaction could be rolled back.
Isolation – This property says that one transaction can not retrive the data that has been modified by any other transaction until its completed.
Durability – When any transaction is committed then it must be persisted. In the case of failure only committed transaction will be recovered and uncommitted transaction will be rolled back.
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Please explain GO Command in SQL Server? | Tell me what is the significance of NULL value and why should we avoid permitting null values? |