Oracle Database Administration I (1Z0-082)

How does TRUNCATE TABLE differ from DELETE without a WHERE clause in Oracle?

TRUNCATE fires row-level triggers; DELETE does not TRUNCATE is DML; DELETE is DDL TRUNCATE removes all rows quickly without generating undo and cannot be rolled back TRUNCATE requires a WHERE clause

Correct Answer:

TRUNCATE removes all rows quickly without generating undo and cannot be rolled back

Access more questions from this quiz

Continue to Oracle Database Administration I (1Z0-082) for more practice questions and the full quiz experience.

Access More Questions