Which statement is true about TRUNCATE and DELETE?
A. You can never TRUNCATE a table if foreign key constraints will be violated.
B. For large tables TRUNCATE is faster than DELETE.
C. For tables with multiple indexes and triggers DELETE is faster than TRUNCATE.
D. You can never DELETE rows from a table if foreign key constraints will be violated.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
sure B
B
(Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables)