Oracle
1Z0-052 · Question #256
1Z0-052 Question #256: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #256. The question stem and answer options stay visible for context.
Question
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?
Options
- 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.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.