Multiple choice technology databases

What is true about the Truncate statement?

  1. It is faster than the Delete operation.

  2. You can roll back the deletion of rows after the statement executes.

  3. You must be the owner of the table or have DELETE ANY TABLE system privileges

  4. It releases the storage space used by the table.
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

TRUNCATE is a DDL statement, making it much faster than DELETE since it resets the high-water mark and releases storage space rather than generating individual undo logs. It requires table ownership or DELETE system privileges, and cannot be rolled back.

Keep practicing — related questions