Databases Interview Questions — All Categories
7 questions tagged with Databases as a technology, across every category it appears in
How does a database schema migration change your deployment strategy for either blue-green or canary — what breaks if you don't account for it?
AdvancedDatabases8 min
Your database backups have been running successfully every night for two years, but nobody has ever actually restored one. Why is that a real risk, and how would you fix it?
IntermediateDatabases6 min
Under a traffic spike, your application starts throwing 'too many connections' errors from the database, even though the database itself isn't under heavy CPU or memory load. What's happening?
IntermediateDatabases7 min
A user updates their profile, immediately reloads the page, and sees their old data — but only sometimes. What's causing this, and how do you fix it?
AdvancedDatabases8 min
How would you design the actual mechanism that decides whether a given database query goes to the primary or a read replica, for an application that wasn't originally built with this split in mind?
AdvancedDatabases8 min
During a network partition, both your old primary and a newly promoted replica briefly accept writes at the same time. How does automatic failover cause this, and how do you design against it?
ExpertDatabases8 min
What's the actual trade-off between synchronous and asynchronous database replication, and how would you decide which to use for a payments system versus an analytics dashboard?
AdvancedDatabases7 min