Database Design Interview Questions

Normalization, indexing, query optimization, ACID properties, and transaction isolation.

51 questions in this section

Database Normalization (Intermediate)
ACID Properties (Intermediate)
Indexing Deep Dive (Advanced)
CAP Theorem (Advanced)
SQL vs. NoSQL (Intermediate)
Isolation Levels (Advanced)
Database Sharding (Advanced)
Replication Strategies (Intermediate)
Referential Integrity (Beginner)
Composite Keys (Beginner)
Stored Procedures (Intermediate)
Denormalization (Intermediate)
Views vs. Materialized Views (Advanced)
Concurrency Control (Advanced)
B-Tree vs Hash Index (Intermediate)
Deadlock Prevention (Intermediate)
Surrogate vs. Natural Keys (Beginner)
Columnar Storage (Advanced)
Consistency Models (Intermediate)
ETL vs. ELT (Intermediate)
Soft Delete (Beginner)
Index Overhead (Beginner)
Unique Constraints (Beginner)
Database Triggers (Intermediate)
Horizontal vs Vertical Partitioning (Intermediate)
UUID as Primary Key (Intermediate)
Fan-out Problem (Advanced)
Write-Ahead Logging (WAL) (Advanced)
Read Replicas vs. Caching (Intermediate)
Full-Text Search (Intermediate)
Checkpointing (Advanced)
Star vs. Snowflake (Intermediate)
Polymorphic Associations (Advanced)
Schema Migrations (Intermediate)
JSONB in SQL (Intermediate)
UPSERT (Beginner)
FK Performance (Intermediate)
Redundancy Risks (Beginner)
Graph Databases (Intermediate)
NoSQL Secondary Indexes (Advanced)
Natural Primary Key (Intermediate)
Covering Index (Advanced)
SELECT * (Beginner)
Execution Plans (Intermediate)
Data Skew (Advanced)
Bulk Inserts (Beginner)
Phantom Reads (Advanced)
Data Archiving (Intermediate)
Vector Databases (Intermediate)
Lock Escalation (Advanced)
Immutable Data (Advanced)

JavaScript is required for the interactive version of this page, including the code playground and progress tracking. Browse all InternHack tutorials.