Why lock is important in SQL?

Related questions

1. What is blocking and how would you troubleshoot it?
2. What is rollback and commit in SQL?
3. When deadlock occurs in SQL Server?
4. What is deadlock lock?
5. What is the difference between commit and rollback?
6. What happens when you encounter a deadlock?
7. Do we need to commit after rollback?
8. Why locks are used in DBMS?
9. How does SQL Server resolve deadlocks?
10. Can SQLite handle multiple users?

Tags

1. #other
2. #transaction
3. #objects
4. #starts
5. #server
6. #consistency
7. #transactions
8. #access
9. #locked
10. #exclusive
11. #occurs
12. #prevent
13. #modify
14. #mechanism
15. #cause
16. #ensure
17. #locks
18. #object
19. #problem