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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 a Lock and let me know Different types of locks?
 Question Submitted By :: Vamsimadineni
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is a Lock and let me know Different types of locks?
Answer
# 1		 
Different Types of Locks are
   1. Shared Lock
   2. Exclusive Lock
   3. Update Lock
 
Is This Answer Correct ?    2 Yes 0 No
Sreejith S T
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person  7
How do you use DBCC statements to monitor various aspects of a SQL server installation?  1
Can we create a clustered index on composite primary key.  2
Why Do you want to work in this company? HCL3
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them? Techno-Solutions1
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?  1
event classes in sql server Accenture1
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..  2
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000? Infosys1
Which system table contains information on constraints on all the tables created?  2
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance.... Siemens6
i need some interview questions on sql server developer plz any onee send some links.  1
Explain Active/Active and Active/Passive cluster configurations?  1
What is a Lock and let me know Different types of locks?  1
What is blocking and how would you troubleshoot it? HCL2
Hi..here i would like to know the Backup and Restore models? HCL2
what is mean by crystal repoart? ahere we will mainly use that?  1
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 do you load large data to the SQL server database?  2
What is the difference between local table and global table Polaris1
 
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