SQL Data Manipulation Language (DML) 3

Question 1

Which statement undoes uncommitted DML changes?

Accepted Answer

ROLLBACK

Answer

ROLLBACK reverts changes made since the last commit.

Question 2

To update multiple columns in one UPDATE, you separate assignments with what?

Accepted Answer

Commas

Answer

Multiple column assignments in SET are separated by commas.

Question 3

What does INSERT INTO table DEFAULT VALUES do?

Accepted Answer

Inserts a row using each column's default value

Answer

DEFAULT VALUES inserts a row where every column takes its default.

Question 4

Which keyword in an UPDATE specifies the new value for a column?

Accepted Answer

SET

Answer

SET assigns new values to columns in an UPDATE.

Question 5

A DELETE statement with a subquery in WHERE is used to do what?

Accepted Answer

Delete rows based on values from another query

Answer

A subquery in WHERE lets DELETE target rows matching a related query's results.

SQL Practice Test