Explanation:Lock is a done by database when any connection access a same piece of data concurrently and another is demanding for it. 5. Point out the wrong statement :
A. SQL Server’s lock monitor has a performance monitor that periodically checks the locks
B. A deadlock graph shows us the sessions and resources that were involved in a deadlock.
C. Prior to SQL Server 2008, if a deadlock occurred in SQL Server, we’d have to enable trace flag
D. None of the mentioned
Answer:A
Explanation:Lock is a done by database when any connection access a same piece of data concurrently and another is demanding for it. 5. Point out the wrong statement :
A. SQL Server’s lock monitor has a performance monitor that periodically checks the locks B. A deadlock graph shows us the sessions and resources that were involved in a deadlock. C. Prior to SQL Server 2008, if a deadlock occurred in SQL Server, we’d have to enable trace flag D. None of the mentioned
Explanation:SQL Server’s lock monitor has a deadlock detector that periodically checks the locks to see if there are any circular locking chains. 6. An XML deadlock graph has ______ main sections.