SQL Server Profiler   «Prev  Next»

SQL Server Profiler - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following are components of SQL Server Profiler?
Please select all the correct answers.
  A. trace
  B. event
  C. profile
  D. filter

2. When you define a trace, you can define which of the following items?
Please select all the correct answers.
  A. The schedule of when to run a trace
  B. The trace name
  C. The information to track
  D. Error generation for the trace

::::
3. Which of the following can you do with a running trace?
Please select all the correct answers.
  A. pause
  B. rerun
  C. stop
  D. end

4. Which event classes are useful to trace whenever you are having any kind of performance problems?
Please select all the correct answers.
  A. TSQL
  B. SQL Operators
  C. Errors and Warnings
  D. Transactions
  E. Stored Procedures
  F. Duration
  G. Event Class
  H. Object ID
  I. Integer Data
  J. Start Time


SQL Server Profiler