Google News
logo
SQL Server - Quiz(MCQ)
Which of the following wait occurs when a task is waiting for I/Os to finish?
A)
ASYNC_NETWORK_IO
B)
AUDIT_LOGINCACHE_LOCK
C)
AUDIT_XE_SESSION_MGR
D)
AUDIT_ON_DEMAND_TARGET_LOCK

Correct Answer :   ASYNC_NETWORK_IO


Explanation : AUDIT_XE_SESSION_MGR occurs when there is a wait on a lock that is used to synchronize the starting and stopping of audit related Extended Events sessions.

Advertisement