Multiple choice

Which command(s) is/are used to remove rows from a table?

  1. Delete

  2. Remove

  3. Truncate

  4. Both (1) and (2)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Both DELETE and REMOVE can remove rows from tables in various database systems. DELETE is standard SQL. TRUNCATE removes all rows but keeps table structure. The question is slightly ambiguous as 'remove' is not standard SQL.

Keep practicing — related questions