Which of the following is DML command ?
2024
Which of the following is DML command ?
- A.
INSERT INTO / INSERT INTO
- B.
DROP TABLE / DROP TABLE
- C.
CREATE TABLE / CREATE TABLE
- D.
ALTER TABLE / ALTER TABLE
Attempted by 2524 students.
Show answer & explanation
Correct answer: A
Answer: INSERT INTO is a DML command.
Explanation: Data Manipulation Language (DML) includes statements that operate on the data (rows) stored in tables.
INSERT INTO — Adds new rows to an existing table (example: INSERT INTO table_name (col1, col2) VALUES (...)). This is a DML operation.
DROP TABLE — Removes an entire table and its data. This changes the database schema, so it is a Data Definition Language (DDL) command.
CREATE TABLE — Defines a new table structure (columns, types, constraints). This is a DDL command that creates schema objects.
ALTER TABLE — Modifies a table's schema (for example, add/drop columns). This is also a DDL command.
Tip: To tell DML and DDL apart: DML manipulates table rows (INSERT, UPDATE, DELETE) and is typically transactional; DDL changes the schema (CREATE, ALTER, DROP) and affects table structures.
A video solution is available for this question — log in and enroll to watch it.