About this sheet
DBMS Interview Questions
The DBMS sheet covers the relational model, entity-relationship modelling, SQL, normalization, storage and indexing, query optimization, transactions, concurrency control and recovery.
The sheet holds 10 patterns and 50 topics, tracked row by row. From any row you can read the theory for a topic, answer knowledge-check questions on it, have the AI coach teach it back to you, keep notes, bookmark a row and mark it done. Progress is saved against your account, so the sheet is also the record of what you have already covered.
Who it is for
It is for candidates with a database round in the loop, and for backend engineers who write queries daily but have never had to defend an index choice or an isolation level.
How to work through it
Anchor every topic to a query you would actually write. Normalization, index selection and isolation levels are trade-offs, and the interview question is nearly always which trade-off you would take here and why.
Practice runs on the same platform as the sheet: 850+ problems across every track, code execution in 6 languages, and AI mock interviews that follow the pattern you are studying rather than a random question.
What the dbms sheet covers
Interview Soon
5 patterns, 25 topics — the ones that come up first
- Database Systems and Architecture — Why Databases Exist, Data Abstraction and the Three-Schema Architecture, Data Models and Database Languages, Database System Structure, Database Users and the DBA
- The Relational Model — Relations, Tuples and Attributes, Keys, Integrity Constraints, Relational Algebra, Relational Algebra: Additional Operations
- Entity-Relationship Modelling — Entities, Attributes and Relationships, Cardinality and Participation Constraints, Weak Entities and Specialisation, Converting an ER Diagram to Tables, Working Through a Complete Design
- SQL — Creating Tables and Basic Queries, Joins, Aggregation and Grouping, Subqueries and Set Operations, Views, Modifications and Access Control
- Normalization — Anomalies and Why Normalization Exists, Functional Dependencies and Attribute Closure, First, Second and Third Normal Form, BCNF and Lossless Decomposition, Higher Normal Forms and When to Stop
Deep Dive
5 patterns, 25 topics for full coverage
- Storage and File Organization — The Storage Hierarchy and Why Disks Shape Databases, Records, Blocks and File Organization, Indexing Basics: Dense, Sparse and Multilevel, B+ Trees, Hash Indexes and Choosing an Index
- Query Processing and Optimization — How a Query Is Processed, Selection and Sorting Algorithms, Join Algorithms, Query Optimization, Reading a Query Plan
- Transactions — Transactions and the ACID Properties, Transaction States and Schedules, Serializability, Recoverability and Cascading Rollback, Isolation Levels
- Concurrency Control — Lock-Based Protocols, Two-Phase Locking, Deadlock Handling in Databases, Timestamp and Validation-Based Protocols, Multiple Granularity and Multiversion Concurrency
- Recovery — Failure Types and the Recovery Problem, Log-Based Recovery, Checkpoints, Recovery After a Crash, Backups and Protecting Against Disk Failure