What is a deadlock and how does SQL Server resolve one?
What will be an ideal response?
A deadlock is a situation in which two transactions each have a lock on a resource that the other transaction needs in order to complete. After a period of time has elapsed, SQL Server deals with this situation by picking one of the deadlocked transactions as the deadlock victim, and it cancels that transaction.
You might also like to view...
Write a SELECT statement to list courses that have the course number 20 as a prerequisite. (5 rows)
What will be an ideal response?
How many CheckBoxes in a GUI can be selected at once?
a) 0 b) 1 c) 4 d) any number
Image file extensions may be in either uppercase or lowercase letters
Indicate whether the statement is true or false
To add a selection with a selection tool, you can hold down the _____ while you draw the selection with the tool
a. Alt key (Window) or Option (Mac OS) b. Ctrl key c. Shift key d. Space bar