Top 50 database design Interview Questions
The most frequently asked database design questions across all roles and companies, ranked by real interview frequency. Updated daily.
Explain 1NF through higher normal forms, including functional dependencies, anomalies, and normalization trade-offs.
Aqr Capital Management
IBMModel product features by combining current lifecycle status, project relationships, and a derived implementation stage.
Autodesk
AirbnbExplain how INNER and LEFT JOIN behavior changes based on primary keys, foreign keys, nullable columns, and unmatched rows.
InfosysDesign a tenant-isolated Mercury ledger schema and report posted account balances with transaction counts.
MercuryAudit user, application, and event relationships to validate completeness and referential integrity.
Mercer France
bet365Describe database normalization and identify how atomic, dependency-based records support data integrity.
Baseten Labs
DaDaModel business requirements as entities and relationships, then report connected and isolated entities with PostgreSQL.
AppleDemonstrate a dimensional data model by reporting monthly TikTok product metrics with complete dimension coverage.
TikTokSign up to see every question
Create a free account to unlock this list and practice real interview questions.