| Snaprecruit.com

| Snaprecruit.com

Interview question based on skill :

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Which of the following is benefit of SQL Server Profiler ?

Correct Answer is : All of the mentioned

2. Point out the correct statement :

Correct Answer is : SQL Server Profiler also supports auditing the actions performed on instances of SQL Server

3. Which of the following is an event class ?

Correct Answer is : SQL:BatchCompleted

4. Which of the following stored procedure will stop the trace ?

Correct Answer is : sp_trace_setstatus

5. 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