Oracle interview questions

Showing 91–104 of 104 results

• Resolve a Customer ProblemMedium

  This question assesses a candidate's ability to navigate high-pressure customer incidents by balancing technical problem-solving with transparent stakeholder communication.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Respond to a Material Scope Change Mid-ProjectEasy

  This question assesses a candidate's ability to handle ambiguity and scope creep by demonstrating a structured, data-driven approach to project recalibration.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Return a valid course completion orderMedium

  This question evaluates understanding of graph algorithms and dependency resolution, specifically skills in cycle detection and producing valid orderings of tasks.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Return the K Most Frequent Values with a Larger-Value Tie-BreakMedium

  This problem tests proficiency with hash maps for frequency counting and custom sorting logic using priority queues or sorting algorithms.

  OracleBackend EngineerCoding & AlgorithmsOnsite
• Shortest Subarray Whose Distinct-Value Sum Reaches a TargetMedium

  Find the length of the shortest contiguous subarray of positive integers whose sum reaches a target when each distinct value is counted only once. A coding-screen problem that tests reasoning about contiguous ranges, bookkeeping for repeated values, and correct handling of the case where no subarray qualifies.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Simulate a Least Recently Used CacheEasy

  This problem tests your ability to maintain data access recency and perform cache evictions in O(1) time complexity using a combination of a hash map and a doubly linked list.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Simulate an LFU cache that evicts the least-used key, breaking ties by recencyMedium

  Implement and simulate a least-frequently-used cache with fixed capacity that evicts the key with the lowest use count, breaking ties by least recent use. It tests exact eviction semantics, treating updates and reads as uses, and supporting every get and put in constant average time.

  OracleSoftware EngineerCoding & AlgorithmsOther
• Solve Five Coding ProblemsMedium

  This set tests proficiency across five key algorithmic domains: graph theory, array manipulation, numerical properties, cache design, and tree traversal.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Solve the Hardest Project ChallengeMedium

  This question tests your ability to structure a high-stakes professional challenge using the STAR method, specifically focusing on how you navigate ambiguity, influence technical decisions, and reflect on trade-offs.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Solve three DSA problems: trie, window, intervalsMedium

  This multi-part question evaluates proficiency with core data structures and algorithms — specifically trie-based string indexing and autocomplete design, sliding-window/prefix-sum optimization for maximizing a one-shot decrypted range, and interval merging — within the Coding & Algorithms domain, emphasizing practical implementation, complexity analysis and edge-case handling. It is commonly asked in technical interviews to assess the ability to design efficient data structures and linear-time algorithms, reason about time/space trade-offs and ordering constraints, and demonstrate both conceptual understanding and practical application through clear complexity analysis.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Split a String into Exactly Three PalindromesMedium

  Tests string partitioning, palindrome verification, and algorithmic optimization using dynamic programming or two pointers.

  OracleBackend EngineerCoding & AlgorithmsOnsite
• Sum the Binary Numbers Spelled by Root-to-Leaf Paths in a 0/1 TreeMedium

  Given a binary tree of 0 and 1 bits in level-order form, return the sum of the binary numbers spelled by every root-to-leaf path, reading the root as the most significant bit. The problem tests tree traversal, carrying an accumulated value down each path, and parsing a level-order serialization correctly.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Take Ownership Through AmbiguityMedium

  This question assesses a candidate's ability to navigate unstructured environments, prioritize tasks under uncertainty, and drive consensus among cross-functional stakeholders.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Timestamped key-value store: return each key's value as of a query timeMedium

  A coding question that processes set and get operations on a key-value store where each write carries a timestamp and each read asks for a key's value as of a given time. It tests per-key version history, finding the latest write at or before a query time, and handling many interleaved operations efficiently.

  OracleSoftware EngineerCoding & AlgorithmsOnsite