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
 
  Re: What is blocking and how would you troubleshoot it?
Answer
# 2		 
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.

sp_who2 will give the list of blocking sessions. From that 
we can find the objects using dbcc command.
 
Is This Answer Correct ?    1 Yes 0 No
Rajkumar
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
to explain sql server 2000 architecture & authentication  1
how to know description of a table in sqlserver 2000  7
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?  1
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3 Google10
how to find nth highest salary NexGen30
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha  4
What is Covering Indexes? Plz explain with example  2
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they. IBM5
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L  4
how to retrive only second row from table in sql server 2000? CTS7
What all db objects can be found in MSDB database of a SQL Server instance? Accenture1
write query for fourth maximum salary from employee table Mind-Tree5
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables? TCS3
what is bit data type? and what are the information that can be stored inside a bit column?  2
How to determine the service pack currently installed on SQL Server? HCL4
Can you give an example of Stored Procedure?  2
What is a join and their types? Challenger-Financial2
Why Do you want to work in this company? HCL3
How m-m relationships are implemented?  1
What is referential integrity? What are the advantages of it? Digital-Domain3
 
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