Multiple choice technology databases

Examine this TRUNCATE TABLE command: - 68 - TRUNCATE TABLE departments; Which statements are true about the command?

  1. All extents are released.

  2. All rows of the table are deleted.

  3. Any associated indexes are truncated.

  4. No undo data is generated for the table's rows.
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

TRUNCATE is a DDL command that removes all rows from a table without generating undo data (it's minimally logged). Unlike DELETE, it doesn't generate undo logs for rollback, making it faster but non-reversible. It also truncates any associated indexes. However, extents are not immediately released back to the system - they remain allocated to the table for reuse. The correct answers are B, C, and D.

Keep practicing — related questions