Microsoft
70-457 · Question #142
70-457 Question #142: Real Exam Question with Answer & Explanation
Sign in or unlock 70-457 to reveal the answer and full explanation for question #142. The question stem and answer options stay visible for context.
Question
You administer a Microsoft SQL Server 2012. A process that normally runs in less than 10 seconds has been running for more than an hour. You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being blocked. Which Transact-SQL statement should you use?
Options
- AEXEC sp_who 60
- BSELECT - FROM sys.dm_exec_sessions WHERE sessionjd = 60
- CEXEC sp_helpdb 60
- DDBCC INPUTBUFFER (60)
Unlock 70-457 to see the answer
You've previewed enough free 70-457 questions. Unlock 70-457 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.