Oracle interview questions

Showing 1–30 of 104 results

• Add One to an Integer Stored as Digits Without ArrayListMedium

  This problem tests array manipulation skills and the ability to handle carry-over logic in fixed-size numerical representations.

  OracleBackend EngineerCoding & AlgorithmsOnsite
• Align Multiple Teams Around a Shared Technical OutcomeEasy

  This question assesses your ability to navigate cross-functional technical dependencies, manage conflicting team priorities, and drive alignment toward a shared objective without formal authority.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Answer Behavioral Leadership QuestionsMedium

  This question assesses a candidate's ability to demonstrate leadership through ownership, conflict resolution, and the ability to influence technical direction in a high-pressure environment.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Apply operations efficiently using Command patternMedium

  This problem tests the application of the Command design pattern to encapsulate, track, and optimize a series of state mutations on a shared object.

  OracleSoftware EngineerSoftware Engineering FundamentalsOnsite
• Approximate a Square Root Across Values Above and Below OneMedium

  This problem tests binary search on a continuous search space and the ability to handle numerical precision for numbers both greater than and less than one.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Behavioral: simplifying a complicated product or system and proving it workedMedium

  A behavioral question asking for a complicated product or system the candidate made simpler. It evaluates how they diagnosed the source of the complexity, decided what to remove or hide, brought users and stakeholders along, and measured whether the simplification actually helped.

  OracleSoftware EngineerBehavioral & LeadershipOther
• Check That a String of Three Bracket Types Is Properly NestedMedium

  Decide whether a string made of round, square and curly brackets is properly nested, meaning every closing bracket matches the most recently opened bracket of the same type and nothing is left open. Tests careful handling of nesting order, crossing pairs and unmatched brackets at either end.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Classify Tree Nodes in SQLMedium

  Tests the ability to write conditional logic and subqueries/joins in SQL to classify hierarchical tree nodes into 'Root', 'Inner', or 'Leaf'.

  OracleSoftware EngineerData Manipulation (SQL/Python)Technical Screen
• Communicate a Difficult Decision to StakeholdersMedium

  This question assesses the candidate's ability to navigate complex stakeholder management, transparent communication, and conflict resolution when technical trade-offs negatively impact project delivery.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Connect Technical Work to Business ImpactMedium

  Tests your ability to bridge low-level engineering implementation with high-level business, operational, or customer outcomes. Evaluates whether you can measure success with rigorous metrics, recognize trade-offs, and acknowledge attribution constraints.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Contribute to a Complex ProjectMedium

  This question assesses a candidate's ability to articulate their specific impact within a team setting, focusing on collaboration, ownership, and technical project management.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Count Closed IslandsMedium

  This problem tests your ability to navigate a 2D grid using graph traversal algorithms like DFS or BFS while identifying connected components that do not touch the grid boundaries.

  OracleData ScientistCoding & AlgorithmsTechnical Screen
• Count Interior Islands After FloodingMedium

  This question evaluates understanding of grid-based graph traversal and connected-component detection, focusing on flood-fill logic and the treatment of boundary-connected regions in a binary grid.

  OracleData ScientistCoding & AlgorithmsTechnical Screen
• Count Islands and Return the Largest Island SizeMedium

  Count four-connected islands and find the largest island using DFS or BFS, with correct visited-state handling and all-water behavior.

  OracleSoftware EngineerCoding & AlgorithmsOnsite
• Count anagram-based replacements per phraseMedium

  This question evaluates skills in string processing, anagram grouping, frequency mapping, and combinatorial counting to determine how many phrase variations arise from permissible replacements in the Coding & Algorithms domain.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Count closed islands in a gridEasy

  This problem tests your ability to navigate a 2D grid using graph traversal algorithms like DFS or BFS while handling specific boundary constraints to identify closed regions.

  OracleData ScientistCoding & AlgorithmsTechnical Screen
• Decide When to Simplify Scope and When to Prioritize a Bug FixEasy

  This question evaluates your framework for prioritizing engineering work when faced with competing demands: feature scope reduction versus choosing between bug fixes and new feature development.

  OracleSoftware EngineerProduct / Decision MakingOnsite
• Decide Whether a Parenthesis String With Star Wildcards Can Be BalancedMedium

  Decide whether a string of parentheses and stars can become a balanced parenthesis string when each star may independently act as an opening parenthesis, a closing parenthesis or an empty string. Tests reasoning over many possible replacements at once and edge cases with unmatched parentheses near either end.

  OracleSoftware EngineerCoding & AlgorithmsTechnical Screen
• Deep-Dive on an Interesting Technical ProjectEasy

  This question assesses the ability to articulate a technical project's scope, architecture, and impact through structured storytelling, focusing on individual contributions and problem-solving skills.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Deep-dive a project and show ownershipMedium

  This question evaluates a candidate's ownership and leadership competencies alongside technical depth, cross-team alignment, communication, and the ability to conduct system and design reviews within software engineering.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Deliver Under a Tight DeadlineMedium

  Evaluates how you handle time-sensitive engineering commitments by ruthlessly prioritizing scope, maintaining technical rigor and data integrity, and driving clear stakeholder alignment under pressure.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Demonstrate Leadership and OwnershipMedium

  This question assesses a candidate's ability to influence team members, manage ambiguity, and drive accountability for project outcomes in the absence of a formal management title.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Describe cross-team collaborationMedium

  This interview question evaluates behavioral evidence, ownership, communication, trade-offs, and measurable outcomes in a realistic interview setting. A strong answer for Describe cross-team collaboration states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

  OracleSoftware EngineerBehavioral & LeadershipOnsite
• Design a Distributed Rate LimiterMedium

  This problem tests the ability to design a scalable, low-latency distributed system for enforcing traffic quotas across multiple geographic regions with considerations for consistency and burst handling.

  OracleBackend EngineerSystem DesignOnsite
• Design a Five-Minute Top-K Error Log ServiceMedium

  Design a fault-tolerant, high-throughput log aggregation service that identifies and ranks the top-K microservices with the highest error counts over a sliding five-minute window.

  OracleSoftware EngineerSystem DesignOnsite
• Design a High-Volume Healthcare Data Ingestion PipelineMedium

  This question tests the ability to design a resilient, high-throughput ETL pipeline for sensitive and messy healthcare data, focusing on fault isolation, data integrity, and architectural scalability.

  OracleBackend EngineerSystem DesignOnsite
• Design a Sliding-Hour Top-100 User Event PipelineMedium

  Design a real-time event-time aggregation pipeline to compute the top 100 most active users over a trailing 60-minute sliding window at scale.

  OracleSoftware EngineerSystem DesignOnsite
• Design a Software Load BalancerMedium

  This problem tests the ability to architect a scalable, fault-tolerant entry point for distributed systems, focusing on request routing, health monitoring, and concurrency management.

  OracleSoftware EngineerSystem DesignOnsite
• Design a Synchronously Replicated Hash MapMedium

  Design an in-memory key-value storage system utilizing active-passive synchronous replication where writes must commit on both nodes or fail atomically.

  OracleSoftware EngineerSystem DesignOnsite
• Design a URL shortener: short-code generation, fast redirects and scalingMedium

  A system design question that asks for a URL shortening service that turns long links into short codes and redirects visitors quickly. It tests requirements and capacity estimates, collision-free short-code generation, redirect caching and status codes, data modeling and partitioning, expiry, analytics and abuse handling.

  OracleSoftware EngineerSystem DesignOnsite