Oracle
1Z0-071 · Question #301
Which statement is true about TRUNCATE and DELETE?
The correct answer is B. For large tables TRUNCATE is faster than DELETE. See the full explanation below for the reasoning.
Question
Which statement is true about TRUNCATE and DELETE?
Options
- AYou can never TRUNCATE a table if foreign key constraints will be violated.
- BFor large tables TRUNCATE is faster than DELETE.
- CFor tables with multiple indexes and triggers DELETE is faster than TRUNCATE.
- DYou can never DELETE rows from a table if foreign key constraints will be violated.
How the community answered
(63 responses)- A5% (3)
- B83% (52)
- C2% (1)
- D11% (7)
Community Discussion
No community discussion yet for this question.