To delete all the rows in a table and free up the storage space that was occupied by those rows,the ____ command should be used.
A) ALTER TABLE...DELETE
B) TRUNCATE ROWS
C) TRUNCATE TABLE
D) DELETE...FROM

Question

To delete all the rows in a table and free up the storage space that was occupied by those rows,the ____ command should be used.​
A) ​ALTER TABLE...DELETE
B) ​TRUNCATE ROWS
C) ​TRUNCATE TABLE
D) ​DELETE...FROM

Quizplus · Accepted Answer

The TRUNCATE TABLE command is the best choice for deleting all rows in a table and freeing up storage space. It is faster and more efficient than using the DELETE command, as it does not log individual row deletions and does not preserve the table structure, indexing, and constraints. ALTER TABLE...DELETE and DELETE...FROM are not appropriate for deleting all rows, as they only delete specific rows based on conditions or criteria. TRUNCATE ROWS is not a valid SQL command.

To Delete All the Rows in a Table and Free