Database Queries interview questions
Database Queries interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 5
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
