Can you 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

What is a covered index?

0 Answers  


You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  


where can you add custom error messages to sql server? : Sql server administration

0 Answers  


Explain boyce and codd normal form(bcnf)?

0 Answers  


what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  






How to receive returning result from a query?

0 Answers  


Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  


What are the common performance issues in sql server?

0 Answers  


How does normalization work?

0 Answers  


How can you insert null values in a column while inserting the data?

0 Answers  


What are the types of database recovery models?

0 Answers   HCL,


Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  


Categories