Transaction Processing Concepts, Concurrency and Recovery Why are operations not

Question

Transaction Processing Concepts, Concurrency and Recovery

Why are operations noted to the log before they are actually performed on database items? A. Logs assist in confirming whether a commit is permissable, as well as note usage of reads, writes, and commits in case of need in recovery. B. If the data is updated and the system crashes, there would be no way to recover transactions that were not logged. C. So the database can validate that a rollback does not occur to that process and every other process that may have a impact on it D. To make sure of atomicity in case of failures. Helps in recovery in case of a failed transaction. Easier to rollback.

Explanation / Answer

D. To make sure of atomicity in case of failures. Helps in recovery in case of failed transaction. Easier to rollback

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.