Multiple choice

Which of the following statements regarding DML statement functionality is true?

  1. UPDATE can update multiple columns in one table.

  2. INSERT must contain a VALUES clause.

  3. MERGE will delete rows that do NOT exist in either table.

  4. UPDATE will add rows to a table if an INTO clause is specified.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

UPDATE can modify multiple columns in one table with a single statement using SET column1=value1, column2=value2. INSERT can use subqueries instead of VALUES. MERGE matches rows to update or insert, not delete. UPDATE doesn't add rows - INSERT does. INTO clause is for subqueries, not UPDATE.

Keep practicing — related questions