What is repeatable read?



What is repeatable read?..

Answer / Pawan Prakash Saxena

"Repeatable Read" is a SQL Server isolation level that ensures that once a transaction reads data, no other transaction can modify or delete the data until the first transaction completes. This means that if a query selects data within a transaction, and the same query is run again during the same transaction, it will return the exact same data as before, even if other transactions have been updating or deleting data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to generate create procedure script on an existing stored procedure?

1 Answers  


How to disable a login name in ms sql server?

1 Answers  


What is the benefit of normalization?

1 Answers  


How to use go command in "sqlcmd"?

1 Answers  


how can i store resumes in database?

3 Answers   HCL,


How to see existing views in ms sql server?

1 Answers  


What is de-normalization and when do you do it?

3 Answers  


What is raiseerror? What is raiseerror?

1 Answers  


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1 Answers  


How can we use ConnectorJ JDBC Driver with MS SQL?

1 Answers   PUCIT,


What is the difference between cartesian product and cross join?

1 Answers  


How to use linked server?

1 Answers  


Categories