Databases
Deadlock
Two transactions each holding a lock the other needs, so neither can proceed.
Why interviewers ask about it
The systematic prevention is a consistent global lock ordering, which makes a wait-for cycle impossible. Beyond that: short transactions and retry logic.
Related terms
This term is part of the free Python Full-Stack interview preparation module - browse the full glossary for every definition.