Which of the following is DML command?

2023

Which of the following is DML command?

Answer: A. INSERT INTOCorrect answer: INSERT INTO Explanation: DML (Data Manipulation Language) commands operate on the data stored in tables — inserting, updating, deleting, or…

  1. A.

    INSERT INTO

  2. B.

    DROP TABLE

  3. C.

    CREATE TABLE

  4. D.

    ALTER TABLE

Attempted by 3380 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: Uppsc Polytechnic Lecturer 2025 Cs

Loading lesson…