Oracle interview questions

Showing 61–90 of 104 results

• Implement Queue Operations Using Two StacksHard

  Implement queue enqueue, dequeue, and peek operations using exactly two LIFO stacks. The challenge tests transfer invariants, output ordering, amortized O(1) reasoning, large operation sequences, empty input, and compliance with restrictions against queue-like shortcuts.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Implement a Key-Value Cache with Fixed TTL, Renewal and a Live-Entry CountEasy

  Implement an in-memory key-value cache whose entries expire a fixed time-to-live after their last write, with put, get, renew and a count of live entries, and write your own tests for it. It tests expiry boundary semantics, renewal rules, efficient cleanup of expired entries and test design.

  OracleSoftware EngineerSoftware Engineering FundamentalsOnsite
• Implement a Paginated Medical-Record Filter Without Guessing an Ambiguous RuleEasy

  This problem tests your ability to handle ambiguous business logic through requirement clarification and implement a robust, paginated filtering system for sensitive data.

  OracleSoftware EngineerSoftware Engineering FundamentalsTechnical Screen
• Implement in-memory data structures and booking APIHard

  This problem tests your ability to design a thread-safe, in-memory booking system using efficient data structures to handle temporal queries and capacity management.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Largest Island After Converting at Most One Water Cell to LandMedium

  Given a grid of land and water, convert at most one water cell to land and return the size of the largest island that can result. An onsite follow-up coding problem that tests connected-component sizing, joining neighboring islands without counting one twice, and efficiency on grids up to 500 by 500.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Leadership and ownership: real examples of leading others and owning an outcomeMedium

  A behavioral interview question that asks for real examples of leading others toward an outcome and of taking ownership of a problem through to the end. It tests specific storytelling, a clear personal contribution, handling disagreement and setbacks, measurable results and honest reflection.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Maximize Movie Ratings Without Skipping Two in a RowMedium

  Find the maximum possible sum of a subsequence such that no two consecutive elements from the original array are omitted.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Maximize Profit with One Stock TransactionMedium

  This problem tests the ability to find the optimal buy and sell points for a stock within a single transaction, focusing on an efficient O(n) single-pass approach.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Maximum of Fixed-Window MinimumsMedium

  Tests the ability to compute sliding-window minima in linear time using a monotonic deque and determine the maximum value among those minima.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Maximum stock trading profit with at most k buy-and-sell transactionsMedium

  Given daily stock prices and a transaction limit k, compute the maximum profit achievable with at most k buy-then-sell trades while holding at most one share at a time. It tests generalizing a fixed-count trading problem, handling a k larger than the available profitable trades, and tracking state efficiently.

  OracleSoftware EngineerCoding & AlgorithmsOther
• Maximum stock trading profit with at most two buy-and-sell transactionsMedium

  A stock trading optimization problem: given daily prices, find the maximum profit using at most two buy-then-sell transactions while holding at most one share at a time. It tests reasoning about splitting the price history into non-overlapping trades and handling falling, flat or steadily rising prices.

  OracleSoftware EngineerCoding & AlgorithmsOther
• Merge Accounts by Shared IdentifiersMedium

  This problem tests graph traversal techniques (BFS/DFS) and Disjoint Set Union (DSU) to group connected entities based on shared attributes.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Minimize sum with halving operationsMedium

  This interview question evaluates algorithm design, data structures, correctness, complexity, edge cases, and implementation details in a realistic interview setting. A strong answer for Minimize sum with halving operations states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Minimum number of rooms needed to hold overlapping meetingsMedium

  A coding question that asks for the minimum number of rooms needed so that every meeting in an unsorted list of half-open time intervals can be held without overlap. It tests reasoning about overlapping intervals, the boundary rule for meetings that end and start at the same time, and an efficient solution for large inputs.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Mitigate an Emergency During On-CallEasy

  This question assesses the candidate's ability to handle high-pressure production incidents by evaluating their structured approach to containment, risk assessment, and post-incident remediation.

  OracleSite Reliability EngineerBehavioral & LeadershipOnsite
• Monitor 100,000 GPU Hosts and Trigger Repair WorkflowsEasy

  This question tests the ability to design a distributed telemetry collection and automated incident remediation system for a large-scale hardware fleet.

  OracleSite Reliability EngineerSystem DesignOnsite
• Move Forward When Requirements Are AmbiguousMedium

  This question assesses a candidate's ability to navigate project uncertainty by balancing proactive problem-solving with effective stakeholder communication.

  OracleSoftware EngineerBehavioral & LeadershipTechnical Screen
• Object-oriented design of a fixed-capacity LRU cache with O(1) get and putMedium

  An object-oriented design question that asks for a fixed-capacity least-recently-used cache whose get and put operations run in constant average time and evict the least recently used entry when the cache is full. It tests class decomposition, data structure choice, recency bookkeeping, edge cases and awareness of thread safety.

  OracleSoftware EngineerSoftware Engineering FundamentalsOnsite
• Parse logs and query by timeMedium

  This question evaluates competency in parsing and structuring log lines, interpreting timestamps and time zones, handling malformed input, designing insert/query APIs, reasoning about scalability and indexing, performing time/space complexity analysis, and planning basic tests.

  OracleSoftware EngineerData Manipulation (SQL/Python)Onsite
• Present Your Proudest ProjectMedium

  This question tests your ability to articulate the narrative arc of a technical project, focusing on your specific contributions, decision-making process, and the long-term impact of your work.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Prioritize Two Critical TasksMedium

  Tests an engineer's ability to evaluate, prioritize, and manage trade-offs when two high-impact, urgent tasks compete for the same engineering capacity, while proactively mitigating risks and communicating with stakeholders.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Process Tokens with Explicit Expiration TimesEasy

  This problem tests your ability to manage temporal data using efficient data structures, specifically focusing on handling expiration logic and range-based queries.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Project deep dive: full architecture diagram, design decisions and business impactMedium

  A project deep-dive interview question that asks you to draw the complete architecture of your current project, defend its key design decisions against alternatives, and explain the business impact of your past work. It tests understanding of the whole system, clear ownership, trade-off reasoning and quantified results under probing.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Propose a Design or Process ImprovementMedium

  This question tests your ability to identify a systemic engineering bottleneck, evaluate trade-offs objectively, and execute a data-backed technical improvement.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Rank Departments by Student CountMedium

  Tests SQL proficiency in outer joins, aggregation with null handling, and deterministic multi-column sorting.

  OracleSoftware EngineerData Manipulation (SQL/Python)Onsite
• Rearrange an Integer Array into Its Next Lexicographic ArrangementMedium

  A coding problem that asks you to rearrange an integer array into the next lexicographically greater arrangement of its values, wrapping around to ascending order when the array is already the largest. It tests reasoning about lexicographic order, repeated values and complexity analysis.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Remove Even-Positioned Nodes from a Linked ListMedium

  This problem tests your ability to manipulate singly linked list pointers in-place, specifically managing alternating node removals while maintaining correct connectivity.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Repeatedly Delete Runs of k Adjacent Equal Characters from a StringMedium

  Given a lowercase string and an integer k, repeatedly delete k adjacent equal characters, letting the remaining parts join and possibly form new runs, until no deletion is possible, then return what remains. It tests efficient simulation of cascading removals on strings of up to 100,000 characters.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Replace a Range of Nodes in a Linked List with Another Linked ListEasy

  Given two singly linked lists and two indices i and j, replace nodes i through j of the first list with every node of the second list and return the new head. It tests careful pointer relinking, head and tail edge cases, and an empty replacement list.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Resolve Conflict Within a TeamMedium

  This question tests your ability to navigate interpersonal and technical disagreements professionally while maintaining team productivity and morale.

  OracleSoftware EngineerBehavioral & LeadershipOnsite