1.

What Is Acid Properties?

Answer»

ACID (an acronym for Atomicity Consistency Isolation DURABILITY) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a RELIABLE database all this four attributes should be achieved.

  • Atomicity is an all-or-none proposition.
  • Consistency guarantees that a TRANSACTION NEVER leaves your database in a half-finished state.
  • Isolation keeps TRANSACTIONS separated from each other until they’re finished.
  • Durability guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination.

ACID (an acronym for Atomicity Consistency Isolation Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved.


Discussion

No Comment Found

Related InterviewSolutions