DBMS Interview Problems
Chapters
| Topic | File |
|---|---|
| Classic SQL Problems | Nth salary, duplicates, top N per group |
| Query Optimization | Execution plans, index usage |
| Join Problems | LEFT JOIN traps, NOT IN nulls, EXISTS vs JOIN |
| Window Function Problems | Top-row-per-group, running totals, gaps-and-islands |
| Concurrency Scenarios | Lost updates, deadlocks, isolation anomalies |