Multiple choice softskills teamwork

Which are DML statements? (Choose all that apply.)

  1. COMMIT

  2. MERGE

  3. UPDATE

  4. DELETE

  5. CREATE

  6. DROP
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

DML (Data Manipulation Language) statements manipulate data in tables: MERGE combines insert/update/delete operations, UPDATE modifies existing data, DELETE removes rows. CREATE, DROP, and COMMIT are DDL and TCL commands respectively. COMMIT is transaction control, not data manipulation.

AI explanation

DML (Data Manipulation Language) statements are those that manipulate data within tables: MERGE, UPDATE, and DELETE are all correctly classified as DML because they insert/modify/remove row data. COMMIT is a TCL (Transaction Control Language) statement — it finalizes a transaction rather than manipulating data itself. CREATE and DROP are DDL (Data Definition Language) statements because they define or remove schema objects (tables, views, etc.) rather than manipulating the data inside them. This maps cleanly onto the standard SQL command category taxonomy (DDL/DML/DCL/TCL) commonly tested in database courses.

Keep practicing — related questions