Which of the following is DML command?

2023

Which of the following is DML command?

  1. A.

    INSERT INTO

  2. B.

    DROP TABLE

  3. C.

    CREATE TABLE

  4. D.

    ALTER TABLE

Attempted by 2575 students.

Show answer & explanation

Correct answer: A

Correct answer: INSERT INTO

Explanation: DML (Data Manipulation Language) commands operate on the data stored in tables — inserting, updating, deleting, or retrieving rows.

  • Common DML commands: INSERT INTO (add rows), UPDATE (modify rows), DELETE (remove rows), SELECT (retrieve rows).

Why the other listed commands are not DML:

  • DROP TABLE — This is a DDL command that deletes a table and its data; it changes the database schema.

  • CREATE TABLE — This is a DDL command used to define a new table (schema definition), not to manipulate row data.

  • ALTER TABLE — This is a DDL command used to modify the structure of an existing table (for example, add or drop columns).

Short summary: INSERT INTO manipulates table data (DML); DROP TABLE, CREATE TABLE, and ALTER TABLE manipulate the schema (DDL).

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Up Lt Grade Assistant Teacher 2025