If you use the BEGIN TRANSACTION statement, then execute 2 insert statements and 2 delete statements what will happen if you execute ROLLBACK TRANSACTION?

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 1275 | Points: 40
Select from following answers:
  1. Only the INSERT statements will be rolled back
  2. Only the last INSERT and last DELETE statement will be rolled back
  3. Only the DELETE statements will be rolled back
  4. All of the INSERTS and DELETES will be rolled back
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response