Multiple choice technology databases

How can a blocking process be killed?

  1. Find the process in System Monitor and select Kill Process.

  2. Find the process in Activity Monitor and select Kill Process.

  3. Find the process in SQL Profiler and select Kill Process.

  4. Find the process in SSRS and select Kill Process.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Activity Monitor in SQL Server Management Studio provides a graphical interface to monitor and manage running processes, including the ability to kill blocking processes. System Monitor, SQL Profiler, and SSRS don't have direct 'Kill Process' functionality for blocking processes.

Keep practicing — related questions