what are the objectives of Transaction properties?

what are the objectives of Transaction properties / ACID properties?

2 Answers
1-2 of  2
2 Answers
  • ACID properties are used so that transaction should posses in order to avoid failures during concurrent access of a database.ACID acronym which stands for atomicity,consistency,isolation and durability.
    Atomicity:(all or none) either transaction should be totally completed or it should be failed
    Consistency:we should not voilate DB integrity constraints
    Isolation:partial results are hidden
    Durability:effects (of transactions that "happened" or committed) are forever

  • ANS: There is a total of four objectives in ACID Properties it includes Atomicity, Consistency, Isolation, and Durability.

Practice Mock Test