Tuesday, 26 January 2016

Outer Transaction is Rollbacked, then what would happned, try to answer: COMMIT/TRAN

Question:  Lets suppose that you have three level nested transaction, and you commit two inner transactions and you roll-backed outer most transaction then what would happened?

Lets you have below query, what would be the output of following query?
How many record would be inserted?
Ans: nothing, If you rollback outer transaction then everything will be roll-backed.
Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompany
Sponsored Ads

1 comment:

  1. Very informative post is this. I like it well and hoping you will be here with more.

    ReplyDelete