SQL · interview question

If you wrote a test around schema thinking, what should the test prove first?

Multiple choiceEasychapter-11-curatedpremiumsqlschema-thinking

sql

CREATE TABLE orders (
  id TEXT PRIMARY KEY,
  customer_id TEXT NOT NULL,
  subtotal_cents INTEGER NOT NULL
);

Keep schema thinking implicit so the script stays short and hope the next engineer infers the rule.That the rule behaves correctly at the boundary cases the lesson is trying to make explicit.Delay clarity until production traffic reveals the edge case and then patch it under pressure.Solve the symptom with comments only and avoid changing the code shape around schema thinking.

Answer and explanation

Correct answer

B. That the rule behaves correctly at the boundary cases the lesson is trying to make explicit.

Why

Good tests make the design safer to change because they lock in the meaningful behavior rather than surface-level implementation details.

Test yourself on SQL

A free test with instant, explained results. No account needed.

Start free test

All SQL questions →

If you wrote a test around schema thinking, what should the test prove first?

Correct answer

Why

More SQL questions