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/