SQLConfiguration SQLConfiguration


Monitoring SQL  «Prev  Next»

Understanding sp_who - Quiz

Each question is worth one point. Select the best answer for each question.
 
1. Examine the following output of sp_who and answer the questions in the quiz:
output of sp_who
Spid 8 is causing which other spids to be blocked?
Please select all the correct answers.
  A. None
  B. 0
  C. 9
  D. 10
  E. 11
  F. 12
  G. 13

2. How many different logins are being used to connect to SQL Server?
Please select the best answer.
  A. 7
  B. 8
  C. 10
  D. 15

3. How many different hosts are the users connecting from?
Please select the best answer.
  A. 7
  B. 8
  C. 9
  D. 15