ACID Properties in DBMS - Interview Question

If you are not a Medium member then you can use below friendly link to read the complete story.

Friendly Link so that everyone can read my article.

It is one of the most asked interview question in the Database Management System. Especially to freshers.

Let’s start with transactions in database systems.

The transaction is the group of operations/tasks which access or modify the data in the database.

Let’s say you have a bank account with a total savings of $30. You have gone to the ATM to withdraw $10. Now, to withdraw $10, ATM needs to do the following operations:

1. var temp = Read → read your total savings from the database i.e. $30.
2. temp = temp - $10 → subtract the amount ATM going to dispatch, so temp = $20.
3. Now, Write $20 into the database.
4. Dispatch the $10.

These 4 operations together are called a single transaction. Transactions can have one or more operations.

Now we need some mechanism to ensure that whatever operations happened within the transaction should not make the database incorrect or corrupt.

That mechanism is called ACID properties which ensures the accuracy of the database…