Database Interview in Technical Lead Round: Expl
More DBA job interview questions and answers at
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.
Other Job Interview Questions