Multiple choice

The UPDATE SQL clause can

  1. update only one row at a time

  2. update more than one row at a time

  3. delete more than one row at a time

  4. delete only one row at a time

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The UPDATE statement modifies all rows that satisfy the WHERE clause. If the WHERE condition matches multiple rows (or is omitted entirely), the UPDATE affects all matching rows simultaneously, not just one.