Multiple choice

Which command is used to remove rows from a table?

  1. Delete

  2. Remove

  3. Truncate

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

In SQL, DELETE removes specific rows based on a condition, while TRUNCATE removes all rows from a table quickly by de-allocating data pages. Both commands are used to remove rows - DELETE is more flexible for selective removal, while TRUNCATE is faster for complete table clearing. REMOVE is not a standard SQL command for this purpose.

Keep practicing — related questions