PrepAway - Latest Free Exam Questions & Answers

What are two possible ways to to solve this blocking situation quickly so that the user can continue using the

TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding during a transaction. You investigate and discover that the user’s session, which is session ID 85, is being blocked by an errant process. The session ID of the errant process is 101. You need to solve this blocking situation quickly so that the user can continue using the application without losing any work. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
In SQL Server Management Studio, open a new query window. Execute the following statement.KILL 85

B.
In SQL Server Management Studio, open a new query window. Execute the following statement.KILL 101

C.
In SQL Server Management Studio, open the Activity Monitor. Open the Process Info page. Right-click session ID 85 and select Kill Process.

D.
In SQL Server Management Studio, open the Activity Monitor. Open the Process Info page. Double-click session ID 101 to show the process details. Click the Kill Process button.

E.
In SQL Server Configuration Manager, stop and then restart the SQL Server (MSSQLSERVER) service.

F.
At a Microsoft Windows command prompt, execute the following statements.NET STOP MSSQLSERVERNET START MSSQLSERVER

Explanation:
You want to KILL the errant process, not the one being blocked. You can kill the process either with a query or from the Process Info page in the SQL Server Management Studio. The Kill command can only be executed by a member of the sysadmin fixed server role.


Leave a Reply