nerdexam
Oracle

1Z0-052 · Question #111

Which two statements are true about checkpointing? (Choose two.)

The correct answer is B. It ensures that all committed data is written to the data files during normal shutdown. C. The frequent full checkpoint in a database can cause the overall degradation of the database performance. Checkpoints guarantee committed data is flushed to data files on normal shutdown, but excessive full checkpoints create heavy I/O overhead that degrades performance.

Exploring the Oracle Database Architecture

Question

Which two statements are true about checkpointing? (Choose two.)

Options

  • AThe checkpoint frequency decreases with the smaller redo log file size.
  • BIt ensures that all committed data is written to the data files during normal shutdown.
  • CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.
  • DIt prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the

How the community answered

(46 responses)
  • A
    4% (2)
  • B
    93% (43)
  • D
    2% (1)

Why each option

Checkpoints guarantee committed data is flushed to data files on normal shutdown, but excessive full checkpoints create heavy I/O overhead that degrades performance.

AThe checkpoint frequency decreases with the smaller redo log file size.

Checkpoint frequency INCREASES with smaller redo log files because each log switch triggers an incremental checkpoint, so smaller logs cause more frequent log switches and thus more frequent checkpoints.

BIt ensures that all committed data is written to the data files during normal shutdown.Correct

During a normal (clean) shutdown, Oracle performs a full checkpoint that directs the Database Writer (DBWn) to flush all dirty buffers from the buffer cache to the data files, ensuring all committed transactions are persisted and the database is in a consistent state.

CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.Correct

A full checkpoint forces DBWn to write every dirty block in the buffer cache to disk simultaneously, generating a large spike in I/O; when full checkpoints occur too frequently, this sustained high I/O load reduces overall database throughput.

DIt prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the

The CKPT process updates the control file and data file headers with checkpoint information, but it is the DBWn (Database Writer) background process that physically writes dirty data blocks to the data files.

Concept tested: Oracle checkpoint process behavior and performance impact

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/oracle-database-instance.html#GUID-C3B9B7F8-B7C4-4D3E-9B4F-8B1E2F5F8B1E

Topics

#checkpoint#CKPT process#redo log files#data file writes

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice