Which of the following is correct about DELETE and TRUNCATE statements?

 Posted by Bandi on 9/26/2013 | Category: Sql Server Interview questions | Views: 1945 | Points: 40
Select from following answers:
  1. The DELETE statement logs information on each row deleted.
  2. The TRUNCATE TABLE statement logs information on each row deleted.
  3. The TRUNCATE TABLE statement executes fast and requires fewer resources on the server.
  4. Only 1 and 3
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response