Which three events signal a database writer (DWR) to write buffers to disk?
A.
The database advances a checkpoint.
B.
A client process commits a transaction.
C.
The redo log buffer becomes full.
D.
A server process cannot find non-dirty blocks after scanning a threshold number of buffers.
E.
A tablespace is changed to read-only status.
F.
The database is shut down in immediate mode.
Explanation:
When tablespace is changed to read only status it will issue a Partial checkpoint. During db shutdown a
checkpoint is also issued. DWR writes when there is a checkpoint.