• The question is: "Which of the following hints require the word WITH? (choose 3) Assume SQL Server 2012.". - Not good.

    The correct answer is: FORCESCAN and FORCESEEK.

    Microsoft: The following table hints are allowed with and without the WITH keyword: NOLOCK, READUNCOMMITTED, UPDLOCK, REPEATABLEREAD, SERIALIZABLE, READCOMMITTED, TABLOCK, TABLOCKX, PAGLOCK, ROWLOCK, NOWAIT, READPAST, XLOCK, and NOEXPAND. When these table hints are specified without the WITH keyword, the hints should be specified alone. - http://technet.microsoft.com/en-us/library/ms187373.aspx

    Igor Micev,My blog: www.igormicev.com