Data Manipulation Language (DML) Flashcards
7 cards from real SQL practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Manipulation Language (DML) flashcards as text
Which DML statement adds new rows to a table?
Answer: INSERT
INSERT adds new rows of data into a table.
What does the WHERE clause do in an UPDATE statement?
Answer: Restricts which rows are updated
WHERE limits an UPDATE to only the rows matching its condition.
Which statement removes all rows but is technically DDL, not DML?
Answer: TRUNCATE
TRUNCATE removes all rows but is classified as DDL because it is not row-by-row logged like DML.
What happens if you run DELETE without a WHERE clause?
Answer: All rows in the table are deleted
DELETE without WHERE removes every row in the table.
Which clause lets you insert results from a query into a table?
Answer: INSERT INTO ... SELECT
INSERT INTO ... SELECT inserts rows produced by a SELECT query.
Which DML statement combines INSERT, UPDATE, and DELETE logic in one operation?
Answer: MERGE
MERGE performs insert, update, or delete based on whether rows match a source.
After a DML change, what statement makes it permanent?
Answer: COMMIT
COMMIT permanently saves the changes made in the current transaction.