OCP 12c题库出现大量新题,062新题-第21题
choose three
Which three statements are true about Oracle checkpoint processing?
A) Incremental checkpoints write some dirty buffers to the datafiles and unwritten redo to the online redo logs.
B) Frequent thread checkpoints can degrade database performance.
C) Thread checkpoints ensure that all dirty buffers are written to data files during a normal shutdown.
D) It reduces the recovery time from instance failures.
E) Database Writer (DBWn) processes write checkpoint information to datafile headers and the control file.
Answer:BCD
(解析:答案BCD比较容易理解,答案E让人觉得是对的,DBWR只负责写脏块,更新检查点信息的事情是由检查点进程来做的。来自3群:1015267481)
【推荐】还在用 ECharts 开发大屏?试试这款永久免费的开源 BI 工具!
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步