令和3年度 ITパスポート試験問75

This question's explanation and your answers so far.

問75

頻出度★☆☆

情報システムに関する機能 a～d のうち, DBMS に備わるものを全て挙げたものはどれか。 a アクセス権管理 b 障害回復 c 同時実行制御 d ファイアウォール

出典　令和3年度 ITパスポート試験問75

解説

問 75

ア
正解 The representative functions provided by a DBMS (database management system) are: a access privilege management (controlling each user’s rights such as query and update), b failure recovery (a recovery function that restores the database to its pre-failure state from logs and backups), and c concurrency control (coordinating concurrent access by multiple transactions with locks and the like to keep consistency). d Firewall is a boundary-defense mechanism that controls network communication and is not a DBMS function. Therefore, the option that lists all functions provided by a DBMS is “ア”, which includes a, b, c.
Incorrectイ
a is correctly a DBMS function, but d firewall is a network security function, not a DBMS function. It also lacks b and c, so it fails to meet the “list all” condition and is incorrect.
Incorrectウ
b failure recovery and c concurrency control are both DBMS functions, but a access privilege management—which is also a DBMS function—is missing, so it does not list all of them and is incorrect.
Incorrectエ
c concurrency control is a DBMS function, but d firewall is not a DBMS function and should not be included. In addition, a and b are also missing, so it is incorrect.

ここがポイント

The main functions of a DBMS include access privilege management, failure recovery (recovery), concurrency control (exclusive control), and confidentiality protection—mechanisms that maintain the integrity and safety of data.
A firewall is a security function at the network boundary and should be distinguished from DBMS functions.

用語

解答問75ア