What is meant by Blocking ?

Posted by Bharathi Cherukuri on 4/30/2012 | Category: Sql Server Interview questions | Views: 3573 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock type.
This forces the second connection to wait, blocked on the first.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to restart SQL Server in single user mode? How ...

Next > : What is RAID ?

Comments or Responses

More Interview Questions by Bharathi Cherukuri

What is RAID ?
What is lock escalation ?
Define Candidate Key ?
What port do you need to open on your server firewall to enable named ...
What level of permissions does a user need to create an assembly with ...
How is the SUBSTR keyword used in SQL ?
Why do we use SET ROWCOUNT in Sql ?
How to get number of Maximum connections can be established to SQL ?

Latest Interview Questions

Web service can only be written in .net?
Where on the Internet would you look for Web services?
How do you turn off cookies for one page in your site?
What is Machine.config?
What is Global Asssembly Cache (GAC)?
What is Page Inspector in VS 2011 ?
What is a Web Service?
What is CTS?
More ...