Number of questions 1,751
Number of tests completed 252,582
Number of questions answered 3,766,864
Number of registered users 19,177
Sign In | Register
Skip Navigation Links
Question: ________ removes all rows from a table without logging the individual row deletions.
Answer1: drop
Answer2: delete
Answer3: Truncate
Answer4: Alter
Answer5: update
Answer: Truncate

Explaination: Removes all rows from a table without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources. TRUNCATE is faster than DELETE due to the way TRUNCATE “removes” rows. Actually, TRUNCATE does not remove data, but rather deallocates whole data pages and removes pointers to indexes. The data still exists until it is overwritten or the database is shrunk. This action does not require a lot of resources and is therefore very fast. It is a common mistake to think that TRUNCATE is not logged. This is wrong. The deallocation of the data pages is recorded in the log file. Therefore, BOL refers to TRUNCATE operations as “minimally logged” operations. You can use TRUNCATE within a transaction, and when this transaction is rolled-back, the data pages are reallocated again and the database is again in its original, consistent state.
Link: External Explaination

Correctly answered: 26224
Incorrectly answered: 11929
Terms of Use Ver. 2.0.6783.38332