You need to remove all the data from the employee table while leaving the table definition intact. You want to be able to undo this operation. How would you accomplish this task?
Answer options
A
DELETE FROM employee;
B
TRUNCATE TABLE employee;
C
DROP TABLE employee;
D
ALTER TABLE employee;
Correct answer: DELETE FROM employee;
Explanation
DELETE is DML and can be rolled back; TRUNCATE cannot be rolled back.