SQL Server interview questions part 21
SQL Server interview questions part 21
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. The following code snippet uses the DELAY keyword to wait for ______ seconds. WAITFOR DELAY '00:00:02'; SELECT BusinessEntityID FROM AdventureWorks2008R2.HumanResources.Employee;
Correct Answer is : 2
2. Which of the following is benefit of SQL Server Profiler ?
Correct Answer is : All of the mentioned
3. Point out the correct statement :
Correct Answer is : SQL Server Profiler also supports auditing the actions performed on instances of SQL Server
4. Which of the following is an event class ?
Correct Answer is : SQL:BatchCompleted
5. Which of the following stored procedure will stop the trace ?
Correct Answer is : sp_trace_setstatus
6. Point out the wrong statement :
Correct Answer is : If a filter is set, all events of the selected event classes are returned in the trace output
7. Which of the following argument has option value 2 in sp_trace_create procedure ?
Correct Answer is : TRACE_FILE_ROLLOVER
8. Which of the following events and their columns are contained in the trace:
Correct Answer is : All of the mentioned
9. TRACE_PRODUCE_BLACKBOX file can be saved in the following location :
Correct Answer is : N’%SQLDIR%\MSSQL\DATA\blackbox.trc
10. Which of the following event has event number 15 in the trace ?
Correct Answer is : SQL:BatchStarting
11. Which of the following syntax is valid ?
Correct Answer is : SET SHOWPLAN_XML { ON | OFF }
12. 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
13. ___________ displays the profile information for a statement.
Correct Answer is : SET STATISTICS PROFILE
14. To produce execution plan output by using most Showplan Transact-SQL SET options, users must have
Correct Answer is : SHOWPLAN
15. Point out the wrong statement :
Correct Answer is : SET SHOWPLAN_XML can be specified inside a stored procedure
16. The document containing the XML schema for the XML output by SET STATISTICS XML is located at :
Correct Answer is : \Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml. xsd
17. Which of the following is valid syntax for SET STATISTICS XML ?
Correct Answer is : All of the mentioned
18. __________ returns detailed information about how the statements are executed.
Correct Answer is : SET SHOWPLAN_TEXT
19. The way that a statement can be physically executed is called :
Correct Answer is : all of the mentioned
20. SET SHOWPLAN_TEXT is intended to return readable output for ________ utility.
Correct Answer is : osql
