what are the objectives of Transaction properties?

what are the objectives of Transaction properties / ACID properties?

  • Vijay
  • 05 Oct
  • 1421 Views
  • 2 Answers
Your Answer

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
 

1
Oracle
Practice Mock Test
Oracle