The ability to query data, as well as insert, delete, and alter tuples, is…
2025
The ability to query data, as well as insert, delete, and alter tuples, is offered by:
- A.
TCL (Transaction Control Language)
- B.
DCL (Data Control Language)
- C.
DDL (Data Definition Language)
- D.
DML (Data Manipulation Language)
Attempted by 1096 students.
Show answer & explanation
Correct answer: D
The correct answer is DML (Data Manipulation Language). DML is the subset of SQL used to access and manipulate data in a database. It includes commands like SELECT (to query data), INSERT (to add tuples), DELETE (to remove tuples), and UPDATE (to alter tuples). Why other options are incorrect: TCL (Transaction Control Language) manages transactions (COMMIT, ROLLBACK) but does not manipulate data directly.
DCL (Data Control Language) handles permissions (GRANT, REVOKE) and access control, not data content.
DDL (Data Definition Language) defines the database structure (CREATE, ALTER, DROP tables) rather than the data inside them.