Explain ACID properties of the database?

All Database systems which include transaction support implement ACID properties to ensure the integrity of the database. ACID stands for Atomicity, Consistency, Isolation and Durability

  • Atomicity: Each transaction is said to be “atomic.” If one part of the transaction fails, the entire transaction fails. Modifications on the data in the database either fail or succeed.
  • Consistency: This property ensures that only valid data will be written to the database. If, for some reason, a transaction is executed that violates the database’s consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules.
  • Isolation: It requires that multiple transactions occurring at the same time not impact each other’s execution.
  • Durability: It ensures that any transaction committed to the database will not be lost.

Tags:

7 comments:

  1. UnknownSeptember 5, 2008 at 1:40 AM

    these are the good definitions ,n i enoy that

    ReplyDelete
  2. AnonymousSeptember 11, 2008 at 7:01 PM

    thanks for these definitions, they're a lot clearer than other ones I've found.

    ReplyDelete
  3. muskaanNovember 22, 2009 at 6:49 AM

    thanks a lot for this answer,, if we ask more questions will u answer,, i need the answer 4 this question, plz help, write short notes on transitive dependency in oracle?

    ReplyDelete
  4. sachindranarayanFebruary 10, 2011 at 2:54 AM

    Thanks alot for this understandable solution,b'cause i could never understood this topic left.Sachindra,Bihar

    ReplyDelete
  5. MayurMarch 11, 2011 at 12:55 AM

    Thanks for Sharing this valuable things.

    ReplyDelete
  6. YogitaJuly 14, 2011 at 4:29 AM

    Thanks for good information.. its easy to understand

    ReplyDelete
  7. yanmaneeeAugust 18, 2020 at 12:21 PM

    louboutin shoes
    vans shoes
    balenciaga shoes
    nike shox
    kyrie 5 spongebob
    curry 7 sour patch
    supreme clothing
    retro jordans
    lebron 17
    kd shoes

    ReplyDelete

Type more interview question answer here

Subscribe to: Post Comments (Atom)