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?()
- AThe modified blocks would be written to the data files.
- BThe modified blocks would be written to the temp files.
- CThe modified blocks would be written to the control file.
- DThe modified blocks would be written to the redo log files.
- EThe modified blocks would be written to the archived redo log files.
- FThe modified blocks would be retained in the database buffer cache.