oracle logo
Oracle· Senior Application Engineer

Oracle | Senior Application Engineer | Hyderabad | April 2025 [Offer]

Location
Hyderabad
Posted
11 Jun 2025
281 reads

Summary

I interviewed for the Senior Application Engineer role at Oracle, Hyderabad, in April 2025, and received an offer after four rounds, which I ultimately declined for a better opportunity.

How it went

Round 1 (In-person)
  1. Given two arrays, sort without extra space
    A = [10, 2, 20, -1]
    B = [1, 5, 25]
    Output:
    A = [-1, 1, 2, 5]
    B = [10, 20, 25]
  2. https://leetcode.com/problems/regular-expression-matching/description/
  3. Implement Singleton class
    • Follow up: How do you prevent creating clones of the singleton class object?
Round 2 (In-person)
  1. Given an array, reorder such that even numbers are pushed to the left side of the array and odd numbers to the right
  2. Given two tables - employee and department. Wite SQL query to find the name of employee with max salary
    • Follow-up 1: Wite SQL query to find the name of employee with second max salary (covering corner cases like multiple employees have max and second max salary)
    • Follow-up 2: Write SQL query to print the max salary of each department
Round 3 (In-person with the Hiring Manager)
  1. Write code to add given number of days to a given date in string format without using date functions. Should Handle leap year case as well
Round 4 (Online meeting with the Vice President)
  1. Given the table employee_salary(eid, salary_credited, month)
    • Write SQL query to find employees with salary greater than 10,00,000
    • Write SQL query to find employees with total salary received so far greater than 50,00,000
  2. Difference between where and having clause
  3. Difference between mysql and postgreSQL
  4. Design movie recommendation app. Write some code for user registration module
  5. Where do you see yourself in 5 years?
  6. Why are you leaving your current organization?
Verdict: Selected

However, I declined the offer as I got a better offer

Compensation details: https://leetcode.com/discuss/post/6833191/oracle-senior-application-engineer-hyder-wqdh/

Questions asked (12)

  1. 01

    Sort Two Arrays Without Extra Space

    Data Structures & Algorithms

    Given two arrays, sort without extra space
    A = [10, 2, 20, -1]
    B = [1, 5, 25]
    Output:
    A = [-1, 1, 2, 5]
    B = [10, 20, 25]

  2. 02

    Regular Expression Matching

    Data Structures & Algorithms

    Open the problem
  3. 03

    Implement Singleton Class with Clone Prevention

    Data Structures & Algorithms

    Implement Singleton class

    Follow up: How do you prevent creating clones of the singleton class object?

  4. 04

    Reorder Array: Even Left, Odd Right

    Data Structures & Algorithms

    Given an array, reorder such that even numbers are pushed to the left side of the array and odd numbers to the right

  5. 05

    SQL Query: Max Salary Employee

    Other

    Given two tables - employee and department. Write SQL query to find the name of employee with max salary

    Follow-up 1: Wite SQL query to find the name of employee with second max salary (covering corner cases like multiple employees have max and second max salary)

    Follow-up 2: Write SQL query to print the max salary of each department

  6. 06

    Add Days to Date String Without Date Functions

    Data Structures & Algorithms

    Write code to add given number of days to a given date in string format without using date functions. Should Handle leap year case as well

  7. 07

    SQL Queries on Employee Salary Table

    Other

    Given the table employee_salary(eid, salary_credited, month)

    Write SQL query to find employees with salary greater than 10,00,000

    Write SQL query to find employees with total salary received so far greater than 50,00,000

  8. 08

    Difference between WHERE and HAVING clause

    Other

    Difference between where and having clause

  9. 09

    Difference between MySQL and PostgreSQL

    Other

    Difference between mysql and postgreSQL

  10. 10

    Design Movie Recommendation App with User Registration

    System Design

    Design movie recommendation app. Write some code for user registration module

  11. 11

    Where do you see yourself in 5 years?

    Behavioral

    Where do you see yourself in 5 years?

  12. 12

    Why are you leaving your current organization?

    Behavioral

    Why are you leaving your current organization?

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!