DBMS Interview Preparation — Notes Index

33 topics, one file per topic.

1. Process vs Thread (see note below)
2. ACID Properties
3. BASE Properties
4. Commit & Rollback
5. Isolation Levels
6. Serializable Isolation & SSI
7. Transaction States
8. MVCC
9. Optimistic vs Pessimistic Locking
10. Two-Phase Locking (2PL)
11. Serializability
12. Deadlocks in Databases
13. B+ Tree Index
14. Clustered vs Non-Clustered Index
15. Hash Index
16. Composite Index & Covering Index
17. Index Selectivity
18. When to Use / Not Use Indexes
19. Normal Forms (1NF/2NF/3NF/BCNF)
20. Denormalization
21. SQL vs NoSQL
22. CAP Theorem
23. Eventual Consistency
24. Checkpointing
25. Two-Phase Commit (2PC)
26. Connection Pooling
27. Database Caching
28. Partitioning
29. ORM Pros and Cons
30. Sharding
31. Replication
32. Read Replicas
33. Vertical vs Horizontal Scaling
34. WAL (Write-Ahead Logging)

Note: Your example filename was 01.Process-vs-Thread.md, but the source PDF's actual topic list starts at "ACID Properties" — there's no Process vs Thread section in this PDF. Files are numbered 01–33 matching the PDF's own table of contents, using the 01.Topic-Name.md format you asked for.