| 4. |
In sp_who output, a session shows status sleeping, but another session's blk column points to it. What does this indicate?
Please select the best answer.
|
| |
A.
|
The sleeping session is idle but may still be holding locks from an earlier, uncommitted transaction |
| |
B.
|
This combination is impossible; sp_who is returning corrupted data |
| |
C.
|
A sleeping session can never actually hold a lock |
| |
D.
|
The sleeping session has already committed its transaction and will clear shortly |