Agreed, I was expecting it to be a trick question. A 2 New Delhi option would've made it less obvious. It is still good to be reminded that the identity column counter doesn't revert to the previous value when a transaction affecting it is rolled back.

Good question but, regardless of whether it was a "deception" or to "throw people off the scent", the lesson was lost in the absence of the fourth option for "1 Boston, 2 New Delhi".

Just seems like a trick was missed, I imagine a lot of people may have gone for this fourth option and when it was pointed out they were wrong they'd learn more because they were focus'ed on why they got it wrong.

_____________________________________________________________________"The difficult tasks we do immediately, the impossible takes a little longer"