ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What is blocking and how would you troubleshoot it?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is blocking and how would you troubleshoot it?
Answer
# 1
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
 
Is This Answer Correct ?    4 Yes 0 No
Swapna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are the magic tables in SQL Server 2000? Infogain5
please tell me the query to get details of the employee having the second largest salary 247Customer8
What is blocking and how would you troubleshoot it?  1
what is difference between primary key and Unique  8
What is the datatype returned by count(*) Asian-CERC18
What is the difference between HAVING clause and the WHERE clause?  4
what is bit data type? and what are the information that can be stored inside a bit column?  2
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE IBM1
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,... ADP5
How to Run a Query on a Remote SQL Server?  2
What types of integrity are enforced by a foreign-key constraint  1
Difference between server.transfer and server.execute method?  1
what is mean by crystal repoart? ahere we will mainly use that?  1
From where can you change the default port?  3
What is SQL server agent? SAP-Labs2
How can u convert the Date to String? TCS4
Hi..here i would like to know the Backup and Restore models? HCL2
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
Can we use Truncate command on a table which is referenced by FOREIGN KEY?  2
In clustered and non clustered indexes which one is faster while executing a query ?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com