Which SQL command deletes all rows from a table without deleting the structural schema, cannot be rolled back easily in some systems, and does not fire delete triggers? MCQ with Answer and Explanation
Which SQL command deletes all rows from a table without deleting the structural schema, cannot be rolled back easily in some systems, and does not fire delete triggers?
A. REMOVE
B. DROP
C. DELETE
D. TRUNCATE
Answer: Option D
Solution (By JKSSB Mock Tests)
TRUNCATE is a DDL command that quickly removes all records from a table by deallocating the data pages, bypassing row-level logging and triggers while leaving the table structure intact.
No comments yet. Be the first to start the discussion!