Interview Questions — Production Scenarios and Performance Debugging

These questions put you in the role of the on-call engineer. The database is misbehaving and you need to diagnose it. Interviewers use these questions to test whether you have real production experience or just academic knowledge.