Which Of The Following Scenario Give Rise To Deadlock There Are #833
Which of the following scenario give rise to deadlock (There are 2 processes)?
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 Performance Tuning and Optimization - SQL Server Blocking - Quiz No.1.
Which of the following scenario give rise to deadlock (There are 2 processes)?
P1 & P2 trying to get to 2 resources R1 & R2. P1 gets a lock on R2 and P2 gets a lock on R2 THEN P1 tries to get a lock on R2 but can’t because it is locked by P2 and P2 tries to get a lock on R1 but can’t because it is locked by P1 P1 & P2 trying to get to 2 resources R1 & R2. P1 gets a lock on R1 and P2 gets a lock on R1 THEN P1 tries to get a lock on R2 but can’t because it is locked by P2 and P2 tries to get a lock on R1 but can’t because it is locked by P1 P1 & P2 trying to get to 2 resources R1 & R2. P1 gets a lock on R1 and P2 gets a lock on R2 THEN P1 tries to get a lock on R2 but can’t because it is locked by P2 and P2 tries to get a lock on R1 but can’t because it is locked by P1
All of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
