In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A
database user updates the rows of the ORDERS table. Because of the configuration, the CKPT
process gets initiated before the user commits the transaction. What would happen to the modified
blocks when the CKPT process is started?
A.
The modified blocks would be written to the data files.
B.
The modified blocks would be written to the temp files.
C.
The modified blocks would be written to the control file.
D.
The modified blocks would be written to the redo log files.
E.
The modified blocks would be written to the archived redo log files.
F.
The modified blocks would be retained in the database buffer cache.
Answer A is correct, however depending on other factors F could also be true,
CKPT does “incremental checkpointing” and it may not actually write out the changed blocks from this un commited SCN to disk on the first occurance of a CKPT, although it will eventually do so even if the user does not commit. Therefore in my humble opinion this question is ambigous.
Peace to all
CKPT does not write data blocks to data files or redo blocks to online redo log files (but another process would write data blocks to data files).
https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT1248