What is a "dead lock"?

Posted by Abhisek on 7/27/2010 | Category: Sql Server Interview questions | Views: 4564

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

A "Dead Lock" happens when two or more transaction is locked from a common resource. In this case each must have to wait for the other to unlock that resource.

Source: Interview | Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is "Functional Dependency"?

Next > : What is "Locking" concept in DBMS?

Comments or Responses

More Interview Questions by Abhisek

What is "Locking" concept in DBMS?
How a pointer stores address?
What is "this" pointer?
Which is called as "Soroban"?
Which assembly represents the core LINQ API?
What is the use of System.Data.DLinq.dll?
What is the use of System.XML.XLinq.dll?
To define abstract method which keyword is used in VB?

Latest Interview Questions

Explain About ref and out parameters?
Name the property of ScriptManager which is used to change the timeout ...
What is the difference between following two statements ? 1. SELECT ' ...
What is Instance-aware and Instance-unaware Services in SQL Server ?
When will SQL Server throw an Error: "MSSQLSERVER ERROR 576" ...
When will you go for SQL Server Authentication instead of Windows Auth ...
Which namespace is required in a class to use DataContract or DataMemb ...
How will you calculate maximum range of "INT" Data Type ?
More ...