ITPEC IP October 2024 Question 27

Topic: DatabasesAlso asked in Spring 2020

Which of the following is a language used for the operation of a relational database?

Explanation

SQL — the language used to operate a relational database.

SQL (Structured Query Language) is the standard database language for relational databases. It defines tables (CREATE TABLE), retrieves data (SELECT), changes data (INSERT, UPDATE, DELETE) and controls access rights (GRANT).

Answer (b)

Why not others:

  • •(a) FAQ — Frequently Asked Questions, a list of common questions and answers, not a language
  • •(c) SSL — a protocol that encrypts communication (succeeded by TLS), not a database language
  • •(d) UML — a modelling notation for diagrams of system design, not for operating a database

Key rule: SQL defines and manipulates relational databases; UML models systems and SSL/TLS secures communication.

Databases · AI-written, may contain errors

Practice this exam

This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.