what are the objectives of Transaction properties?

what are the objectives of Transaction properties / ACID properties?

• Vijay
• 1805 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

  ---

• what do you mean by hash join algorithm in query?
• What is difference between Oracle and SQL? What is the use of Oracle?
• need some technical questions for practice purpose.
• please share educational qualification details?
• what is Cloud Computing and how it is useful to us?
• Oracle 1Z0-1042-23 Exam Certification Study Guide 2023
• what is known as bulk scanning and bulk loading?
• (Success-Tips)! Pass Oracle 1Z0-133 Exam Certification Questions & Answers 2023
• Is there any separate coding test for Oracle ?
• What is called as the Virtual Processor in database?