Kizspy | Question: 50
(Choose 1 answer)
Choose the incorrect statement about DELETE and TRUNCAT in SQL Server.
A. DELETE is used for unconditional removal of data records from Tables; TRUNCATE is used for conditional removal of data records from Tables.
B. DELETE is a DML command and the operations are logged, whereas TRUNCATE is a DDL command and the operations are not logged.
C. DELETE removes records and records each deletion in the transaction log whereas TRUNCATE deallocates pages and records each deallocation in the transaction log.
D. TRUNCATE is generally considered quicker as it makes less use of the transaction log
