Database Administrator
Row Locks questions
20 questions on Row Locks for database administrators, easiest first.
Easy 5
Medium 5
Hard 10
- Foreign key checks and row lockshard
- One UPDATE blocks the whole tablehard
- Throughput of one hot counter rowhard
- INSERT hangs on another sessionhard
- FOR UPDATE on a join locks too muchhard
- Many share locks on one rowhard
- SELECT FOR UPDATE creates WALhard
- Guarding a rule across many rowshard
- Two locking options comparedhard
- Locked rows come back out of orderhard