IPA IP 2025 Question 82
A question IPA Japan published in 令和7年度 ITパスポート試験 公開問題 問82, translated into English. ITPEC is based on the same exams.
Which of the following is the DBMS function that copies the contents of the database on one computer to the database on another computer, and synchronizes them so that the contents of both match?
Explanation
Replication — the DBMS keeps a copy (replica) of a database on another computer and keeps the two in step.
With replication, updates made to the master database are sent to the replica, either at once (synchronous) or a little later (asynchronous), so both hold the same contents. It is used to spread read load over several servers, to keep a standby copy that can take over when a server fails, and to keep data close to users at distant sites.
Answer (c)
Why not others:
- •(a) Archive — moves old data that is rarely used to long-term storage; it is not kept in sync with a live database
- •(b) Backup — a copy taken at a point in time for recovery; it is not updated each time the original changes
- •(d) Rollback — undoes the updates of a transaction that did not complete, returning the database to its state before the transaction
Key rule: Replication = a continuously synchronised copy on another computer; backup = a point-in-time copy; rollback = undo an unfinished transaction.
Databases · AI-written, may contain errors
This question comes from the past questions IPA Japan publishes, translated into English by ITPEC Practice. ITPEC Practice is an independent study tool and is not affiliated with IPA or ITPEC. See the original paper (PDF) or Report an issue.