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
how to implement locking in sql server
 Question Submitted By :: Ravi148
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how to implement locking in sql server
Answer
# 1
no need to impliment locks sql server automatically holds 
locks
 
Is This Answer Correct ?    0 Yes 0 No
Rama Krishna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is WITH CHECK OPTION Karur-Vysya-Bank-KVB2
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  2
why cluster and non clusterindex are used in sqlserver 2000? explain with example  1
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?  3
explain different types of jions with examples briefly? Zensar3
how to change column into row in sql  1
What is a stored procedure?  3
can we call functions from stored procedure in SQL Server 2005 ? How?  2
What are cursors? Name four types of cursors and when each one would be applied? Adea-Solutions1
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM3
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance.... Siemens6
What is normalization and its forms? Challenger-Financial3
Is it possible to create tables in stored procedures using a variable for the table name?  1
What are the OS services that the SQL Server installation adds?  1
Can we use Truncate command on a table which is referenced by FOREIGN KEY?  1
what is the query and condition to delete datas in sql server.  1
create index a on employee(dno) In this,which index was created?  1
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required  2
How do SQL server 2000 and XML linked?  1
What is the difference between windows authentication and sql server authentication HCL3
 
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