IPA IP 2021 Question 75
A question IPA Japan published in 令和3年度 ITパスポート試験 公開問題 問75, translated into English. ITPEC is based on the same exams.
Among the functions A through D concerning information systems, which of the following lists all and only those that are provided in a DBMS?
Explanation
A, B and C — access rights management, failure recovery and concurrency control are standard DBMS functions; a firewall is a network device.
A DBMS (database management system) manages data shared by many users and programs, and provides:
- •Access rights management (A) — grants or revokes each user's rights to read, insert, update or delete each table, for example with SQL's GRANT and REVOKE
- •Failure recovery (B) — uses logs and backups to roll back incomplete transactions and roll forward committed ones after a failure
- •Concurrency control (C) — locking or similar methods so that simultaneous transactions do not leave the data inconsistent
A firewall (D) filters traffic between networks, for example between the Internet and an internal LAN. It protects the network the database server sits on, but it is a separate device or program, not a function of the DBMS.
Answer (a)
Why not others:
- •(b) A, D and (d) C, D — include the firewall, which is not a DBMS function, and leave out functions the DBMS does have
- •(c) B, C — leaves out access rights management, which a DBMS provides
Key rule: A DBMS keeps shared data secure (access rights), consistent under simultaneous use (concurrency control) and recoverable after failures (logs and backups).
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.