What is deadlock lock?

Related questions

1. What is rollback and commit in SQL?
2. Can we use Nolock in view?
3. What is blocking and how would you troubleshoot it?
4. What is DB lock file?
5. Is read uncommitted the same as Nolock?
6. Why lock is important in SQL?
7. What is sqlite Journal file?
8. What happens when you encounter a deadlock?
9. What is lock escalation?
10. How does SQL Server resolve deadlocks?

Tags

1. #therefore
2. #distinct
3. #because
4. #correct
5. #resistant
6. #entry
7. #spring
8. #rotating
9. #cannot
10. #position
11. #locking
12. #except
13. #without
14. #deadbolt
15. #mechanism
16. #moved