Monitoring SQL  «Prev  Next»

SQL Server System - Quiz

Each question is worth one point. Select the best answer for each question.

1. To find out what the current connections to SQL Server are, you use which stored procedure?
Please select the best answer.
  A. sp_connection
  B. sp_who
  C. sp_user
  D. sp_helpuser

2. When running sp_monitor SQL Server produces the following output:
Please select the best answer.
  A. 14
  B. 1
  C. 7
  D. 6

3. Which of the following tools can be used to check for locking problems?
Please select all the correct answers.
  A. sp_lock
  B. sp_who
  D. sp_monitor