Exam 1z0-071 Topic 9 Question 239 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 239
Topic #: 9
Which statement is true about TRUNCATE and DELETE?

Suggested Answer: A Vote an answer

A: True. TRUNCATE is generally faster than DELETE for removing all rows from a table because TRUNCATE is a DDL (Data Definition Language) operation that minimally logs the action and does not generate rollback information. TRUNCATE drops and re-creates the table, which is much quicker than deleting rows one by one as DELETE does, especially for large tables. Also, TRUNCATE does not fire triggers.
References:
* Oracle documentation specifies that TRUNCATE is faster because it doesn't generate redo logs for each row as DELETE would.
* TRUNCATE cannot be rolled back once executed, since it is a DDL command and does not generate rollback information as DML commands do.

by Chasel at Apr 07, 2026, 10:29 AM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

0
0
0
10