Which of the following are true about DELETE and TRUNCATE statements?
Each correct answer represents a complete solution. Choose all that apply.
A.
TRUNCATE can drop the storage being used by the table.
B.
DELETE statements require a COMMIT to confirm the DELETE.
C.
DELETE should be used when a conditional delete is to be performed.
D.
TRUNCATE is better if all the rows are to be deleted from a table.