These are HLD questions of the kind Oracle actually asks — the patterns reported from Oracle's AI-engineering rounds, where design trade-offs, scale and failure modes matter as much as definitions. Treat this page as a mock interview: say every answer out loud before revealing it. If one surprises you, the lesson behind it is linked at the bottom.
Oracle HLD concept questions
Oracle interviewers (given the company's database heritage) often ask candidates to justify a SQL vs NoSQL choice rigorously rather than by trend. What are the concrete questions that should decide it?
Asked in
An Oracle interviewer asks: your reporting dashboard reads from a read replica that lags the primary database by up to 5 seconds. Is this an acceptable design, and what would make it unacceptable?
Asked in
Oracle HLD applied & hands-on questions
Oracle-style: a database needs to shard a orders table by customer_id. Compare range-based sharding (customer_id ranges 1-1M, 1M-2M, ...) versus hash-based sharding, and recommend one with justification.
Asked in
How to use this page: Oracle rarely asks something you've never seen — they ask a standard HLD concept and then push one level deeper ("why?", "what would you do if..."). Master the concept in the HLD course lessons, and the follow-up stops being scary.
Keep practising: Caching Explained, Databases at Scale, Design a URL Shortener and Interview Framework cover what most Oracle HLD rounds test.