Do you know what are the differences between lost updates and uncommitted dependencies?
Submitted by: AdministratorLost 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online SQL Server Locks Job Interview Questions And Answers
Top SQL Server Locks Questions
| ☺ | What is a live lock? |
| ☺ | Do you know what guidelines should be followed to help minimize deadlocks? |
| ☺ | What is a dead lock? |
| ☺ | Explain what is lock escalation and what is its purpose? |
| ☺ | Explain optimistic and pessimistic concurrency? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
