Interview Questions — Core PostgreSQL Concepts (With Answers)

These are the conceptual questions that distinguish senior candidates. They cannot be answered by memorising syntax — they require understanding of how PostgreSQL actually works.