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   SiteMap shows list of All Categories in this site.
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
How can you see what type of locks used?
 Question Submitted By :: Senthilsjc
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can you see what type of locks used?
Answer
# 1
sp_lock to view type of lock applied
 
Is This Answer Correct ?    4 Yes 0 No
Ranjit
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Where do you think the users names and passwords will be stored in sql server?  3
How can u convert the Date to String? TCS4
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages. 247Customer3
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?  1
What is database replicaion? What are the different types of replication you can set up in SQL Server?  2
What is a view? is View updatable? IBM11
How do you troubleshoot SQL Server if its running very slow?  2
Questions regarding Raiseerror?  1
What are the main control-of-flow T-SQL constructs?  1
What is the difference between constraints and triggers? Wipro6
What is the system function to get the current user's user id? TCS3
what is the importence of the trigger in sqlserver2000? ATI1
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.  1
What is the use of placing primary key and foreign key constrains on columns. Value-Labs2
what is normalization? what is denormalization? Satyam5
plz send every query in sql server2000 Infosys1
please tell me the query to get details of the employee having the second largest salary 247Customer8
write the query for taking database restore in sql?  2
How to find the last update record in SQL Server?  3
what is index seek and index scan?  2
 
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