To permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?
Answer options
A
TRUNCATE TABLE student;
B
DELETE FROM student;
C
DROP TABLE student;
D
ALTER TABLE student;
Correct answer: TRUNCATE TABLE student;
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.