1. Which of the following syntax is valid ?
Correct Answer is : SET SHOWPLAN_XML { ON | OFF }
2. Point out the correct statement :
Correct Answer is : The setting of SET SHOWPLAN_XML is set at execute or run time and not at parse time
3. ___________ displays the profile information for a statement.
Correct Answer is : SET STATISTICS PROFILE
4. To produce execution plan output by using most Showplan Transact-SQL SET options, users must have
Correct Answer is : SHOWPLAN
5. Point out the wrong statement :
Correct Answer is : SET SHOWPLAN_XML can be specified inside a stored procedure