Exam 70-762 topic 1 question 162 discussion

HOTSPOT -
You have a database named Database1.
Users report that they experience deadlock issues. You run the sp_readerlog stored procedure. You view the output from the Process List section as shown in the Process List exhibit. (Click the Process List tab.)

You view the contents of the Resource List section as shown in the Resource List exhibit. (Click the Resource List tab.)

You view deadlock information as shown in the Deadlock List exhibit. (Click the Deadlock List tab.)

You need to identify the causes of the deadlock.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Hot Area:

Suggested Answer: Explanation
Box 1: No -

The following three lock types are used for row- and page-level locking:
Shared (S)
Exclusive (X)
Update (U)
An exclusive lock reserves a page or row, but not a whole table, for the exclusive use of a single transaction.
Note: Read committed specifies that statements cannot read data that has been modified but not committed by other transactions.

Box 2: No -
Taskpriority is 0, which is the default priority. The transaction could be chosen as the victim if other transactions have a priority higher than 0.


Box 3: Yes -
and

References:
https://www.sqlshack.com/what-is-a-sql-server-deadlock/
https://logicalread.com/sql-server-lock-modes-mc03/#.XULCdm8zaUk