WHEN A DML STATEMENT EXECUTES, WHAT HAPPENS

13. When a DML statement executes, what happens? (Choose the best 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.