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. 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
  C. sys.dm_tran_locks
  D. sp_monitor

3. In the output of sp_monitor, what does the connections column actually represent?
Please select the best answer.
  A. The number of login attempts, successful or not, since SQL Server was last started
  B. The number of sessions currently open
  C. The number of currently blocked sessions
  D. The maximum number of connections allowed on the instance

4. Which SQL Server lock mode is used as a transitional step before converting to an exclusive lock, specifically to help prevent conversion deadlocks?
Please select the best answer.
  A. Shared (S)
  B. Exclusive (X)
  C. Update (U)
  D. Intent Exclusive (IX)

5. Which of the following has Microsoft formally deprecated in favor of the sys.dm_tran_locks Dynamic Management View?
Please select the best answer.
  A. DBCC CHECKDB
  B. sys.dm_exec_sessions
  C. sp_monitor
  D. sp_lock