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