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 ?

A. SET SHOWPLAN_XML { ON | OFF }

B. SET SHOWPLAN { ON | OFF }

C. SET SHOW_XML { ON | OFF }

D. None of the mentioned

Correct Answer is : SET SHOWPLAN_XML { ON | OFF }

2. Point out the correct statement :

A. SET SHOWPLAN_TEXT causes Microsoft SQL Server to execute Transact-SQL statements

B. The setting of SET SHOWPLAN_ALL is set at execute or run time and not at parse time

C. The setting of SET SHOWPLAN_XML is set at execute or run time and not at parse time

D. None of the mentioned

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.

A. SET STATISTICS

B. SET STATS PROFILE

C. SET STATISTICS PROFILE

D. All of the mentioned

Correct Answer is : SET STATISTICS PROFILE

4. To produce execution plan output by using most Showplan Transact-SQL SET options, users must have

A. SHOW SHOWPLAN

B. SHOW PLAN

C. SHOWPLAN

D. None of the mentioned

Correct Answer is : SHOWPLAN

5. Point out the wrong statement :

A. SET SHOWPLAN_XML can be specified inside a stored procedure

B. SET SHOWPLAN_XML returns information as a set of XML documents

C. SET SHOWPLAN_XML is intended to return output as nvarchar(max) for applications such as the sqlcmd utility

D. All of the mentioned

Correct Answer is : SET SHOWPLAN_XML can be specified inside a stored procedure

Database Queries interview questions