🎴 Flashcard Mode
Database Concepts and SQL Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which command will delete all data from a table and will not write to the rollback segment?
AnswerClick to flip back
A
TRUNCATE
💡 Explanation:
TRUNCATE is a DDL command that deallocates data pages without logging individual row deletions, so it doesn't write to rollback segments. DELETE is a DML operation that logs each deletion for rollback. DROP removes the entire table structure, not just its data.