SQL · interview question
Which option is the safer default when shipping code around schema thinking?
Multiple choiceHardchapter-11-curatedpremiumsqlschema-thinking
CREATE TABLE orders (
id TEXT PRIMARY KEY,
customer_id TEXT NOT NULL,
subtotal_cents INTEGER NOT NULL
);Answer and explanation
Correct answer
D. Choose the simpler shape that keeps the rule obvious, validated, and easy to observe in logs or tests.
Why
The safest default is usually the one that lowers ambiguity and makes errors easier to diagnose.
Test yourself on SQL
A free test with instant, explained results. No account needed.
More SQL questions
- If you wrote a test around schema thinking, what should the test prove first?
- What do interviewers usually hear as a strong signal when you discuss schema thinking well?
- Which naming or modeling choice is strongest for schema thinking?
- What is the healthiest performance judgment around indexes and access patterns?
- Which option treats joins as an engineering policy decision instead of a syntax trick?
- A senior interviewer asks for one tradeoff behind joins. What is the strongest follow-up?