令和7年度 ITパスポート試験問82

This question's explanation and your answers so far.

問82

頻出度★★☆

あるコンピュータのデータベースの内容を他のコンピュータのデータベースに複製して, 両者の内容が一致するように同期させる DBMS の機能はどれか。

出典　令和7年度 ITパスポート試験問82

解説

問 82

Incorrectア
Archiving is a function that moves rarely used old data to another location for long-term storage. Its purpose is to preserve data, not to continuously synchronize two databases so their contents match, so it is incorrect.
Incorrectイ
Backup is a function that creates and stores copies of data in preparation for failures. It does create copies, but its purpose is storage for recovery, not continuously synchronizing the two so their contents always match, so it is incorrect.
ウ
正解 The correct answer is ウ, replication. Replication is a DBMS function that copies the contents of one database to a database on another computer and then also reflects subsequent updates, so that the contents of both are always kept matching (synchronized). This enables load balancing, higher availability, referencing data at a remote site, and so on. It corresponds exactly to the stem’s description of copying and synchronizing so that both contents match, so ウ is correct.
Incorrectエ
Rollback is a function that, when a failure occurs during transaction processing, returns data to its state before the update to restore consistency. It is a process that reverts the internal state of a single database, and is unrelated to copying or synchronizing to a database on another computer, so it is incorrect.

ここがポイント

Replication = a DBMS function that copies the contents of a database to another system and reflects updates so that both contents are kept matching (synchronized). Used for load balancing and improving availability.
Distinguishing similar terms: archiving (long-term storage), backup (storing copies for recovery), and rollback (reverting to before an update) are all different concepts.

用語

解答問82ウ