Which of the following statement is true ?
A. DELETE does not free the space containing the table and TRUNCATE free the space containing the table.
B. Both DELETE and TRUNCATE free the space containing the table.
C. Both DELETE and TRUNCATE does not free the space containing the table.
D. DELETE free the space containing the table and TRUNCATE does not free the space containing the table.
Answer:A
Which of the following statement is true ?
A. DELETE does not free the space containing the table and TRUNCATE free the space containing the table. B. Both DELETE and TRUNCATE free the space containing the table. C. Both DELETE and TRUNCATE does not free the space containing the table. D. DELETE free the space containing the table and TRUNCATE does not free the space containing the table.
Explanation:The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.