How do you detect, analyze, and resolve deadlocks in a production database? Walk through your approach from detection to prevention.

Sample answer preview

Deadlocks occur when two or more sessions hold locks that the other sessions need, creating a circular dependency that cannot resolve itself. The database engine detects this cycle and chooses a victim to terminate, allowing the others to proceed.