Oracle Database 12c SQL 1z0-071 Question # 68 Topic 7 Discussion

Oracle Database 12c SQL 1z0-071 Question # 68 Topic 7 Discussion

1z0-071 Exam Topic 7 Question 68 Discussion:
Question #: 68
Topic #: 7

Which statement is true about TRUNCATE and DELETE?


A.

For large tables TRUNCATE is faster than DELETE.


B.

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


C.

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


D.

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


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.