SQL Database Concepts Question:

Do you know what are ACID properties?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

Answer:

ACID is used in database and it includes the following properties such as atomicity, consistency, isolation and durability. These properties allow easy, reliable and secure database transaction. Example: Transfer of money from one bank account to another. It is used to manage the concurrency in the database table.


Previous QuestionNext Question
Explain candidate key, alternate key, and composite key?Tell me what is the difference between Locking and multi-versioning?