4 — Mock Interview Problems
Purpose
[stub: mock-interview-problems]
Metadata
| Author | Amit Singh |
| Scope | dbms |
Local graph
Related notes
1 — Frequently Asked Interview Questions
Covers the recurring DBMS comparison questions asked in interviews — ACID vs BASE, clustered vs non-clustered indexes, B-tree vs B+-tree, 2PL vs MVCC, OLTP vs OLAP, and normalization vs denormalization.
2 — SQL Coding Interview
Covers a SQL coding interview practice set spanning easy through hard window-function and recursive SQL problems.
3 — Internal Architecture Deep Dive
Covers internals deep dives across PostgreSQL, MySQL InnoDB, Oracle, and SQL Server.
Database Management Systems
A book-shaped table of contents for DBMS: relational foundations through SQL mastery, storage internals, transactions, distributed databases, NoSQL, and MAANG interview prep — cross-linking existing system-design/patterns notes instead of duplicating them.