• 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 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP