Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 167

Which statement is true about TRUNCATE and DELETE?

For tables with multiple indexes and triggers DELETE is faster than TRUNCATE.

For large tables TRUNCATE is faster than DELETE.

You can never TRUNCATE a table if foreign key constraints will be violated.

You can never DELETE rows from a table if foreign key constraints will be violated.

Correct Answer: B

For large tables, TRUNCATE is faster than DELETE because TRUNCATE operations drop and re-create the table, which is a more efficient process compared to deleting rows one by one.

Discussion

DarnunOption: B

https://www.examtopics.com/discussions/oracle/view/15064-exam-1z0-071-topic-1-question-268-discussion/

lucemqyOption: B

B correct answer should be B

jm9999Option: B

the exception to C is if the constraint is self referential which contradicts the user of 'never' in the statement

Ricx24Option: B

The correct answer is B (Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables)