Question

Which of the following commands is used to delete all rows and free up space from a table?

• A. Drop
• B. Delete
• C. Truncate
• D. Alter

Hint:

Use TRUNCATE when you need to quickly delete all rows and free up space. It's faster and more efficient than DELETE.

Answer 1

The Correct Option is C

The TRUNCATE command is used to delete all rows from a table, freeing up space by deallocating the space used by the table. Unlike the DELETE command, TRUNCATE does not log individual row deletions, making it faster for large tables. Drop and Alter are used for removing tables or altering table structure.