Which set of SQL language commands is used to query and update a database?

2024

Which set of SQL language commands is used to query and update a database?

  1. A.

    Data Definition Language (DDL)

  2. B.

    Both Data Control Language (DCL) and Data Definition Language (DDL)

  3. C.

    Data Control Language (DCL)

  4. D.

    Data Manipulation Language (DML)

  5. E.

    Question not attempted

Attempted by 1100 students.

Show answer & explanation

Correct answer: D

SQL commands are categorized into different types based on their functionality. To query and update a database, the appropriate command set must be used. Data Manipulation Language (DML) DML includes commands such as SELECT, INSERT, UPDATE, and DELETE. These commands are used to retrieve data from the database (querying) and modify existing data (updating). Data Definition Language (DDL) DDL commands like CREATE, ALTER, and DROP are used to define or modify the database structure (e.g., tables, schemas). They do not query or update data. Data Control Language (DCL) DCL commands such as GRANT and REVOKE manage user access and permissions. They are not used for querying or updating data. Therefore, the correct set of commands for querying and updating a database is Data Manipulation Language (DML).

Explore the full course: Up Lt Grade Assistant Teacher 2025