Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,


What is proper subset of candidate key?

0 Answers  


What are the main sources of data?

0 Answers  


I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  


What are the two types of concurrency?

4 Answers  






What are the advantages of sql stored procedure?

0 Answers  


What is the Disadvantage of indexed sequential file.

0 Answers   HCL,


Explain the steps to use transact-sql cursor?

0 Answers  


Define the one-to-one relationship while designing tables.

0 Answers  


How to Insert multiple rows with a single insert statement?

0 Answers  


What are joins in sql and what are the different types of joins?

0 Answers  


How to execute stored procedure in select statement sql server?

0 Answers  


Categories