Question

Which of the following statement is true?

DELETE free the table space while TRUNCATE does not.
Both TRUNCATE and DELETE statements free the table's space.
Both TRUNCATE and DELETE statement does not free the table's
space.
TRUNCATE free the table space while DELETE does not.​

Answer 1

Explanation:

3rd one) both TRUNCATE and DELETE statements does not free the table's

Answer 2

Answer:

The answer to the given question is:

3) Both TRUNCATE and DELETE statement does not free the table's

space.

Explanation:

Deletes all rows from a table or specified section of a table without registering individual row deletions. TRUNCATE TABLE is equivalent to a DELETE statement without a WHERE clause. However, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.

Quickly remove all rows from a set of tables. It has the same effect as an unnormalized DELETE per table but is faster because it doesn't actually scan the table. It also frees up disk space immediately without subsequent VACUUM operations. This is most useful for large tables.

SQL DELETE query is used to remove an existing record from a table.

You can use a WHERE clause with a DELETE query to delete selected rows. Otherwise, all records will be deleted.

#SPJ3