SQL Data Manipulation Language (DML) 2

Question 1

Which DML statement adds new rows to a table?

Accepted Answer

INSERT

Answer

INSERT adds new rows of data into a table.

Question 2

What does the WHERE clause do in an UPDATE statement?

Accepted Answer

Restricts which rows are updated

Answer

WHERE limits an UPDATE to only the rows matching its condition.

Question 3

Which statement removes all rows but is technically DDL, not DML?

Accepted Answer

TRUNCATE

Answer

TRUNCATE removes all rows but is classified as DDL because it is not row-by-row logged like DML.

Question 4

What happens if you run DELETE without a WHERE clause?

Accepted Answer

All rows in the table are deleted

Answer

DELETE without WHERE removes every row in the table.

Question 5

Which clause lets you insert results from a query into a table?

Accepted Answer

INSERT INTO ... SELECT

Answer

INSERT INTO ... SELECT inserts rows produced by a SELECT query.

SQL Practice Test