Hi All,

Yes, I agree with some members that the question is a bit ambiguous, but I put the third option to make the question “ambiguous” i.e. to make you think a bit more about. Just review the first note on the following link http://msdn.microsoft.com/en-us/library/ms175464.aspx.

I also put a sqlservercentral post to clarify the third option of this QotD: http://www.sqlservercentral.com/Forums/Topic157655-8-1.aspx#bm157658

Yes, the question is about SQL server by default, if it was for Oracle or another database, it would have been appointed.

The question is inspired by practice, and I didn’t have any intention to put ambiguity in answering it.

Thank You

IgorMi