When a DML statement executes, what happens? ( Choose the best answer.) Choose o

Question

When a DML statement executes, what happens? (Choose the best answer.) Choose one answer. A. Both the data and the undo blocks on disk are updated, and the changes are written out to the redo stream. B. The old version of the data is written to an undo segment, and the new version is written to the data segments and the redo log buffer. C. Both data and undo blocks are updated in the database buffer cache, and the updates also go to the log buffer. D. The redo log buffer is updated with information needed to redo the transaction, and the undo blocks are updated with information needed to reverse the transaction. When a DML statement executes, what happens? (Choose the best answer.) Choose one answer. A. Both the data and the undo blocks on disk are updated, and the changes are written out to the redo stream. B. The old version of the data is written to an undo segment, and the new version is written to the data segments and the redo log buffer. C. Both data and undo blocks are updated in the database buffer cache, and the updates also go to the log buffer. D. The redo log buffer is updated with information needed to redo the transaction, and the undo blocks are updated with information needed to reverse the transaction. Choose one answer. A. Both the data and the undo blocks on disk are updated, and the changes are written out to the redo stream. B. The old version of the data is written to an undo segment, and the new version is written to the data segments and the redo log buffer. C. Both data and undo blocks are updated in the database buffer cache, and the updates also go to the log buffer. D. The redo log buffer is updated with information needed to redo the transaction, and the undo blocks are updated with information needed to reverse the transaction.

Explanation / Answer

C. Both data and undo blocks are updated in the database buffer cache, and the updates also go to the log buffer.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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