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
Quick AnswerThe correct answer is DELETE FROM employee; because it directly addresses the core logic of Database Management.
DELETE is DML and can be rolled back; TRUNCATE cannot be rolled back.