what are the objectives of Transaction properties?

what are the objectives of Transaction properties / ACID properties?

• Vijay
• 1931 Views
• 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.br /Atomicity:(all or none) either transaction should be totally completed or it should be failedbr /Consistency:we should not voilate DB integrity constraintsbr /Isolation:partial results are hiddenbr /Durability:effects (of transactions that "happened" or committed) are foreverbr / 

  • K deeksha
  • 28 Jul
  • 0 Comment

  1

  ---

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

  • Vijay
  • 14 Jul
  • 0 Comment

  0

  ---

• Oracle 1Z0-1042-23 Exam Certification Study Guide 2023
• Oracle 1Z0-1109-23 Exam Certification Study Guide 2023
• Can anyone share exam pattern of the oracle placement exam?
• what do you mean by hash join algorithm in query?
• what is basically client server systems?
• Oracle Recruitment Registration Process, Step by Step Process, user profile
• what is Cloud Computing and how it is useful to us?
• Oracle Recruitment application proces, Oracle test registration fee, CV
• (Success-Tips)! Pass Oracle 1Z0-497 Exam Certification Questions & Answers 2023
• i have all the modules(quant,verbal, reasoning, automata) papers of cognizant and infosys and capgemini and tcs, ibm, mindtree, accenture .. and also i have Amcat, cocubes,elitmus materials , if anyon