You connect to a database instance and execute a DML command that changes one data block. The block is
read from the buffer cache, modified, and modified, and marked as dirty. You commit the transaction. What
must take place before the block can be written to disk?
A.
The buffer must be written to flash cache.
B.
A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it
wrote.
C.
The modified data block must be moved from the LRU list to the write queue.
D.
The database must advance the checkpoint.