Interview Questions

Database Interview in Technical Lead Round: Explain the meaning of the expression ACID transaction.

Technical Lead Round Interview Questions and Answers


(Continued from previous question...)

Database Interview in Technical Lead Round: Explain the meaning of the expression ACID transaction.

ACID means Atomic, Consistency, Isolation, Durability, so when any transaction happen it should be Atomic that is it should either be complete or fully incomplete. There should not be anything like Semi complete. The Database State should remain consistent after the completion of the transaction. If there are more than one Transaction then the transaction should be scheduled in such a fashion that they remain in Isolation of one another.Durability means that Once a transaction commits, its effects will persist even if there are system failures.

(Continued on next question...)

Other Interview Questions