SQL Server Locks Question: Download Questions PDF
Do you know what are the differences between lost updates and uncommitted dependencies?
Answer:
Lost updates
Last update overwrites other updates
Cannot report on data that does not exist.
Data is lost
Uncommitted dependencies
Access a row being updated by others.
May report on data that does not exist
Updates are lost
Last update overwrites other updates
Cannot report on data that does not exist.
Data is lost
Uncommitted dependencies
Access a row being updated by others.
May report on data that does not exist
Updates are lost
Download MS SQL Server Locks Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain isolation levels that SQL server supports? | Explain what are the events recorded in a transaction log? |