what are the objectives of Transaction properties / ACID properties?
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