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;
Explanation
Quick AnswerThe correct answer is TRUNCATE TABLE student; because it directly addresses the core logic of Database Management.
TRUNCATE permanently removes all rows but keeps the table structure intact; it cannot be rolled back.