Oracle
1Z0-497 · Question #121
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…
The correct answer is B. A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last. See the full explanation below for the reasoning.
Question
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?
Options
- AThe buffer must be written to flash cache.
- BA log writer (LGWR) must write all redo entries that have been copied into the buffer since the last
- CThe modified data block must be moved from the LRU list to the write queue.
- DThe database must advance the checkpoint.
How the community answered
(24 responses)- A4% (1)
- B83% (20)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.