a) TCL (Transaction Control Language)
b) DCL (Data Control Language)
c) DDL (Data Definition Langauge)
d) DML (Data Manipulation Langauge)
DML (Data Manipulation Language) is the language component responsible for manipulating data within a database. This includes the operations you mentioned:
- Querying data: Retrieving information from the database.
- Inserting data: Adding new records to the database.
- Deleting data: Removing existing records from the database.
- Altering data: Modifying the values of existing records.
Brief overview of other options:
- DDL (Data Definition Language): Defines the structure of the database, including creating, modifying, and dropping tables, indexes, and other database objects.
- DCL (Data Control Language): Deals with access control to the database, granting or revoking privileges to users.
- TCL (Transaction Control Language): Manages the integrity and consistency of data through transactions (commit, rollback, savepoint).
So, DML is the correct choice for performing actions on the data itself.