Multiple choice technology databases

The UPDATE SQL clause can…

  1. update more than one row at a time.

  2. delete more than one row at a time.

  3. update only one row at a time.

  4. delete only one row at a time.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The UPDATE statement in SQL can modify multiple rows in a single execution. When the WHERE clause matches multiple rows, all those rows are updated simultaneously. UPDATE does not delete rows - that's what DELETE does. It can update one or many rows depending on the WHERE condition.

Keep practicing — related questions