oracle logo
Oracle· SDE - I

ORACLE Interview Experience | SDE - I

Posted
6 May 2025
432 reads

Summary

I had an interview experience at Oracle for an SDE-I role, where I encountered questions covering Java/OOP concepts, Data Structures & Algorithms including LeetCode problems, and a specific SQL query on manager hierarchy.

How it went

Interview Experience at Oracle

1. Brief Introduction

I started the interview with a quick introduction about myself, my background, and my experience working with Java and data structures and algorithms.


2. Java/OOP Questions

The interviewer asked several Java questions centered around the four pillars of Object-Oriented Programming:

  1. Encapsulation
  2. Abstraction
  3. Inheritance
  4. Polymorphism

3. Data Structures & Algorithms (DSA) Questions

  1. LeetCode 179: Largest Number
  2. Symmetric Tree Check
    • Problem: Determine if a binary tree is symmetric in structure (ignoring node values).
  3. Subset Sum Equal To K

4. SQL Question

Problem Statement:

Given an Employee table with the following schema:

EmployeeManager
E1E2
E2E3
E3E4
E5E6

Write a SQL query that, for a given employee name, returns all managers in the reporting hierarchy.

  • Example 1: Input: E1 → Output: E2, E3, E4
  • Example 2: Input: E5 → Output: E6

Hint: You may need to use a recursive common table expression (CTE) to traverse the hierarchy.

WITH RECURSIVE ManagerHierarchy AS (
  SELECT Employee, Manager
  FROM EmployeeTable
  WHERE Employee = 'E1'     -- Replace 'E1' with the desired employee

UNION ALL

SELECT e.Employee, e.Manager FROM EmployeeTable e INNER JOIN ManagerHierarchy mh ON e.Employee = mh.Manager ) SELECT Manager FROM ManagerHierarchy;


These were the questions I encountered during my Oracle interview. Hope this helps others preparing for similar interviews!

Questions asked (4)

  1. 01

    Largest Number

    Data Structures & Algorithms

    Given a list of non-negative integers, arrange them such that they form the largest number.

    Open the problem
  2. 02

    Symmetric Tree Check (Structure Only)

    Data Structures & Algorithms

    Determine if a binary tree is symmetric in structure (ignoring node values).

  3. 03

    Subset Sum Equal To K

    Data Structures & Algorithms

    Given a set of integers and a target sum K, determine if any subset of the integers sums to K.

    Open the problem
  4. 04

    SQL Query: Find All Managers in Reporting Hierarchy

    Other

    Given an Employee table with the following schema:

    EmployeeManager
    E1E2
    E2E3
    E3E4
    E5E6

    Write a SQL query that, for a given employee name, returns all managers in the reporting hierarchy.

    • Example 1: Input: E1 → Output: E2, E3, E4
    • Example 2: Input: E5 → Output: E6

    Hint: You may need to use a recursive common table expression (CTE) to traverse the hierarchy.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Oracle recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!