Koen Verbeeck (3/28/2012)

---

Good to see questions on SQL Server 2012.

I did find the question itself poorly phrased, because of the use of "other" and the general term "options".

When I look at the reference, I see the following:

contained, uncontained, partial, non-contained

So it looks like there are more two correct answers, but there is no explanation given why some are correct and others aren't.

edit: after reading the reference a few times, it makes more sense 😀