Question

Which of the following statement is true?

Select the correct answer from below options:

a) TRUNCATE free the table space while DELETE does not.

b) Both TRUNCATE and DELETE statements free the table's space.

c) Both TRUNCATE and DELETE statement does not free the table's space.

d) DELETE free the table space while TRUNCATE does not.

Answer 1

a) TRUNCATE free the table space while DELETE does not.

The TRUNCATE statement in SQL removes all data from the table and free the table's space.

SQL's DELETE statement removes all data from the table but does not free the table's space.