Oracle interview questions

Design an Order Management AI Assistant

Design an LLM-powered AI agent that allows clients to check order status, query policy information from documents with citations, and includes capabilities for prompt testing…

Companies: Oracle, Robinhood

Last reported Mar 2026

Meeting Rooms III

Assign each meeting (with unique start times) to the lowest-numbered available room or delay it (keeping its duration and prioritizing earlier original start times) until…

Companies: Oracle, Apple, Docusign, Google +2

Array · Hash Table · Heap (Priority Queue) · Simulation

Last reported Mar 2026

Maximum Average Subarray I

Given an array nums and an integer k, return the maximum average of any contiguous subarray of length k. This is a classic sliding-window problem…

Companies: Oracle

Last reported Feb 2026

Maximum Sum Subarray from Ends

Given an array of integers and an integer k, find the maximum possible sum by selecting exactly k elements from either the front or back…

Companies: Oracle

Last reported Feb 2026

Best Time to Buy and Sell Stock III

Given daily stock prices, find the maximum profit achievable with at most two non-overlapping buy-sell transactions (you must sell before buying again). Expect to exploit…

Companies: Oracle, Meta

Last reported Feb 2026

Best Time to Buy and Sell Stock IV

Given a price array and integer k, maximize total profit using at most k non-overlapping buy-sell transactions (cannot hold multiple stocks simultaneously). This is a…

Companies: Oracle

Last reported Feb 2026

Design Instagram

Photo delivery and social feeds: safe publication, celebrity fan-out, stable pagination, and high-volume interactions.

Companies: Oracle, Amazon, Bloomberg, Datadog +9

content-delivery · feed-fanout · idempotency · media-storage

Last reported Feb 2026

Design Uber

Design a ride-sharing service like Uber that allows users to request rides, matches them with nearby drivers, handles real-time tracking, and processes payments.

Companies: Oracle, Airbnb, Amazon, Google +5

Last reported Feb 2026

Design YouTube Likes System

Design a system that allows users to like and unlike videos, efficiently stores and retrieves like counts, provides real-time aggregated metrics for content creators and…

Companies: Oracle

Last reported Feb 2026

LFU Cache

Implement an LFU cache with O(1) average-time get and put operations that evicts the least-frequently-used key when capacity is exceeded, breaking ties by least-recently-used…

Companies: Oracle, Amazon, Apple, Cisco +3

Design · Doubly-Linked List · Hash Table · Linked List

Last reported Feb 2026

Tell me about a complicated product that you made simpler

Companies: Oracle, Amazon, Lockheed Martin, Meta +1

Last reported Feb 2026

Tell me about a project of your choice and its challenges

Companies: Oracle, Apple, Atlassian, Bloomberg +7

Last reported Feb 2026

Tell me about a time when you made an error in judgment.

Companies: Oracle, Airbnb, Amazon, Databricks +2

Last reported Feb 2026

Best Time to Buy and Sell Stock II

Given daily stock prices, compute the maximum profit you can achieve with unlimited buy/sell operations while holding at most one share at a time (you…

Companies: Oracle, Apple, Bloomberg, Meta

Array · Dynamic Programming · Greedy

Last reported Jan 2026

Design a URL shortener like Bitly

Read-heavy key-value service: unique short-code generation, hot-key caching, redirect semantics.

Companies: Oracle, Amazon, Anduril, Apple +26

API Design · caching · hot-keys · http-redirects

Last reported Jan 2026

Give me an example of a calculated risk that you have taken where speed was critical.

Companies: Oracle, Amazon, Meta, Smartsheet

Last reported Jan 2026

Tell me about a time when you had a conflict with a peer and you were wrong

Companies: Oracle, Meta

Last reported Jan 2026

Tell me about a time you received critical feedback from your manager. How did you respond to it, and what did you learn?

Companies: Oracle, CrowdStrike, Duolingo, Grab +4

Last reported Jan 2026

Tell me about one of the biggest accomplishments in your career so far.

Companies: Oracle, Google, Meta, Zscaler

Last reported Jan 2026

Tell me about one project you are proud of and how you would do it differently if you could redo it

Companies: Oracle, Okta

Last reported Dec 2025

Design a News Aggregator System

Design a news aggregation system like Google News that allows users to subscribe to different news sources, categories, and topics, then view a personalized real-time…

Companies: Oracle, Amazon, Atlassian, Google +6

Last reported Dec 2025

Max Area of Island

Given an m×n binary grid, find the maximum area (number of cells) of a 4-directionally connected component of 1s (an island), returning 0 if none…

Companies: Oracle, Amazon, LinkedIn, Meta

Last reported Dec 2025