Explanation:Events or columns cannot be added or removed from this trace. 9. TRACE_PRODUCE_BLACKBOX file can be saved in the following location :
A. N’%SQLDIR%\MSSQL\DATA\blackbox.trc
B. N’%SQLDIR%\MSSQL\DATA\black.trc
C. N’%SQLDIR%\MSSQL\DATA\box.trc
D. None of the mentioned
Answer:A
Explanation:Events or columns cannot be added or removed from this trace. 9. TRACE_PRODUCE_BLACKBOX file can be saved in the following location :
A. N’%SQLDIR%\MSSQL\DATA\blackbox.trc B. N’%SQLDIR%\MSSQL\DATA\black.trc C. N’%SQLDIR%\MSSQL\DATA\box.trc D. None of the mentioned
Explanation: The default file_count is 2 but can be overridden by the user using filecount option. 10. Which of the following event has event number 15 in the trace ?