Which of the following is DML command?
2023
Which of the following is DML command?
- A.
INSERT INTO
- B.
DROP TABLE
- C.
CREATE TABLE
- 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.