Multiple choice technology databases

Which SQL statement is used to delete data and its tablespace from a database?

  1. DELETE

  2. TRUNCATE

  3. REMOVE

  4. None of the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNCATE removes all rows and resets the table. DELETE removes rows but preserves tablespace. REMOVE is not a standard SQL command.

Keep practicing — related questions