In-memory database with basic SQL

1Give yourself 5 minutes
2Answer out loud, not in your head
3Then compare with the answer below

Reference answer

Then expect these follow-ups

  • How would you add `GROUP BY`?

  • `ORDER BY`?

  • Indexed lookups via B-trees?

  • How would you shard across 16 nodes?

  • How would you test it (correctness fuzzing vs property-based testing)?

Hiring now

Get the interview, not just the prep

landed applies to roles like these for you, on each company’s own site, with answers written for the role.

Get 5x interviews10 free auto-applies. No card.
Or practice this question first

Next question