The info I looked at refers to the Enterprise Edition.

Thanks for the question.

I almost guessed one of the other answers.

Thanks for the question.

I've created shortcuts in the past to display the sql behind a stored procedure.

Thanks for the question.

I'll have to take that quiz.

Thanks for the question.

Thanks for the question.

I figured it supported at least two of them. Since it was a radio button response the answer had to be all of them.

Thanks for the question.

I concur with the other responses. I got tripped up with this one too.

Thanks for the question.

John Mitchell-245523 (10/9/2014)

---

The question assumes that XACT_ABORT is set to OFF. I know that's the default, but it would be worth mentioning in the question or explanation for clarity...

patrik.ljunggren (10/9/2014)

---

There are no one completely correct answer.

A1 are the most correct.

If the answer hade been "The insert succeeds and the update fails BUT when are both rolled back".

Have I...