令和8年度 ITパスポート試験問56

This question's explanation and your answers so far.

問56

頻出度★☆☆

DBMS におけるチェックポイントの説明として, 適切なものはどれか。

出典　令和8年度 ITパスポート試験問56

解説

問 56

Incorrectア
Finalizing (committing) a transaction's series of operations when the transaction ends normally describes a commit, not a checkpoint.
Incorrectイ
Restoring the database to the state it was in before processing began when a transaction is not processed normally describes a rollback, not a checkpoint.
Incorrectウ
A state in which multiple transactions wait for each other to release locks so that processing cannot proceed describes a deadlock, not a checkpoint.
エ
正解 A checkpoint is the operation of collectively writing out, at a certain point in time, the results of data updates made in memory (buffer) by multiple transactions to external storage such as an HDD, or the point in time at which that operation is performed. When a failure occurs, recovery processing (roll-forward / rollback) needs to use only the log entries recorded after the most recent checkpoint, which shortens the time required for recovery. Choice エ states exactly this — the operation, or point in time, of writing the in-memory update results to external storage in a single batch — so it is the correct answer.

ここがポイント

A checkpoint is the operation, or point in time, of writing the in-memory (buffer) update results out to external storage in a batch; it serves as the starting point for failure recovery and shortens recovery time.
The key point is not to confuse it with the terms commit (finalize), rollback (undo), and deadlock (mutual lock waiting).

用語

解答問56エ