SQL Data Manipulation Language (DML) 2

Question 1

Which DML statement adds new rows to a table?

Accepted Answer

INSERT

Answer

UPDATE

Answer

CREATE

Answer

ALTER

Question 2

What does the WHERE clause do in an UPDATE statement?

Accepted Answer

Restricts which rows are updated

Answer

Sorts the results

Answer

Groups the rows

Answer

Joins two tables

Question 3

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

Accepted Answer

TRUNCATE

Answer

DELETE

Answer

INSERT

Answer

MERGE

Question 4

What happens if you run DELETE without a WHERE clause?

Accepted Answer

All rows in the table are deleted

Answer

Nothing changes

Answer

Only one row is deleted

Answer

An error is raised

Question 5

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

Accepted Answer

INSERT INTO ... SELECT

Answer

INSERT VALUES ONLY

Answer

SELECT INTO WHERE

Answer

UPDATE FROM SELECT

Question 6

Which DML statement combines INSERT, UPDATE, and DELETE logic in one operation?

Accepted Answer

MERGE

Answer

UPSERT only

Answer

REPLACE

Answer

ALTER

Question 7

After a DML change, what statement makes it permanent?

Accepted Answer

COMMIT

Answer

SAVE

Answer

FLUSH

Answer

CLOSE