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;
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.