Your question is Concurrency Control in Databases. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
How do you handle concurrency control in a multi-threaded database environment?
Discuss how multiple threads safely read and write shared database state. Cover transaction isolation, locking or optimistic concurrency, deadlock handling, consistency guarantees, and how you would test correctness under contention.
