Database Testing / Quiz
Migration Drill
Up, down, expand, contract. Testing schema migrations like the rollback will actually be used one day, because it will, at 3 a.m.
- Difficulty
- Medium
- Format
- Quiz
- Points
- 150
- Estimate
- 10 min
// MISSION BRIEF
Your Mission
A migration that only works forward is a one-way door. This quiz covers migration testing discipline: the down path, destructive rollbacks, expand-contract for zero downtime, and why a 10-row dev database rehearses nothing.
Scoring: timed quiz; accuracy first, speed bonus for fast clean runs.
// FIRST CONTACT
Battle teaser
Down migrations deserve explicit testing because:
- AMigration tools refuse to run untested downs
- BThey run automatically after every deploy
- CThey don't; downs are never actually used
- DRollback is the emergency path, executed under maximum stress; an untested down script fails exactly when nothing else is going right
Answers, scoring, hints, and the full battle stay sealed.
// SKILL TAGS
database-testingmigrationszero-downtimesql