Q.Which of the following is a DML command in SQL ? (A) UPDATE (B) CREATE (C) ALTER (D) DROP

Concept: SQL command classification — DML (Data Manipulation Language) commands operate on the data inside tables, not on the table structure itself.

1. DML commands include SELECT, INSERT, UPDATE, DELETE — they modify or retrieve data. …

The key to this question is understanding the four categories of SQL commands: DDL, DML, DCL, and TCL. Most exam questions test whether you can tell apart DDL (structure-changing) from DML (data-changing).

DDL (Data Definition Language) commands define or modify the schema — the structure of tables, databases, indexes, etc. They include CREATE, ALTER, DROP, TRUNCATE, RENAME. These commands auto-commit and cannot be rolled back in most databases.

DML (Data Manipulation Language) commands work on the data inside existing tables — inserting, updating, deleting, or retrieving rows. The classic DML commands are SELECT, INSERT, UPDATE, DELETE. Some exams also include MERGE (upsert) and CALL (for procedures) as DML, but the core four are what matter here.

Now let's check each option:

1. Option (A): UPDATE — This modifies existing rows in a table. It changes data values, not the table structure. This is a classic DML command. ✓ …