SQL · interview question

What does a strong engineer do when reasoning through schema thinking code?

Multiple choiceMediumchapter-11-curatedpremiumsqlschema-thinking

sql

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

Solve the symptom with comments only and avoid changing the code shape around schema thinking.Delay clarity until production traffic reveals the edge case and then patch it under pressure.Keep schema thinking implicit so the script stays short and hope the next engineer infers the rule.Narrate the data shape, the state changes, and the exact rule order step by step.

Answer and explanation