Multiple choice

The SQL UPDATE statement can...

  1. Update only one row at a time

  2. Update multiple rows at a time

  3. Delete a row based on a where clause

  4. Update the current system time of the database

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

The UPDATE statement can modify multiple rows at once if the WHERE clause matches multiple records, or if no WHERE clause is specified at all. It does not delete rows, which is the job of the DELETE statement.

Keep practicing — related questions