問95
頻出度★★☆
関係データベースの操作を行うための言語はどれか。
平成31年度 春期 ITパスポート試験 問95
テクノロジ系データベース › データ操作
This question's explanation and your answers so far.
解説
問 95
Incorrectア
FAQ stands for “Frequently Asked Questions”, a document format that answers users' common questions in advance. It is not a language for operating a database, so it is incorrect.
- イ
正解 The correct answer is イ, “SQL”. SQL (Structured Query Language) is the standard language for operating a relational database (RDB). It can express data operations such as retrieving data from a table (SELECT), adding rows (INSERT), updating (UPDATE), and deleting (DELETE), as well as defining tables and setting permissions. Relational operations such as “selection”, “projection”, and “join” listed in the glossary are also realized through SQL queries. Therefore, the language used to operate a relational database is イ, SQL.
Incorrectウ
SSL (Secure Sockets Layer) is a security protocol that encrypts Web communication and other traffic so that data can be exchanged safely; it is not a language for operating a database, so it is incorrect.
Incorrectエ
UML (Unified Modeling Language) is a unified modeling notation for expressing the structure and behavior of a system with diagrams, used to visualize a design. It is not a language for operating a database, so it is incorrect.
ここがポイント
- SQL is the standard language for operating a relational database, and it can express operations such as retrieving (SELECT), adding, updating, and deleting data.
- FAQ (a Q&A collection), SSL (an encrypted-communication protocol), and UML (a modeling notation) are all not database-operation languages; distinguish them by the meaning of each abbreviation.
用語