Hi Everyone,

I'm sharing my Oracle Interview Experience at the Gandhinagar, Gujarat branch.

I was invited for a walk-in interview on Saturday, May 9th, 2025.

There were multiple invitations for the same day, and my slot was around 12:30 PM IST.

There were a total of 3 rounds of interviews, with 2 conducted on the same day. The 3rd round took place on the following Monday, May 11th, 2025.

I'm sharing my experience for each round below.

1st Round

Question 1 - Puzzle I have 4 pairs of socks in different colours:

• 1 Pair of Red
• 1 Pair of Green
• 1 Pair of Blue
• 1 Pair of Yellow

I want to arrange these pairs with the following conditions:

• The Red pair will have exactly 1 other sock in between them.
• The Blue pair will have exactly 2 other socks in between them.
• The Green pair will have exactly 3 other socks in between them.
• The Yellow pair will have exactly 4 other socks in between them.

Answer: YRGRBYGB

Question 2 - Java I want to reverse the words in the given string. The position of spaces should remain the same. String str = "Hello Param How are You Welcome to oracle"; Answer String: "olleh maraP woH era uoY emocleW ot elcaro";

Question 3 - Java Find the longest continuous substring without repeating characters from the given string. String str = "abcdba"; Answer: abcd Approach: Sliding Window

Question 4 - Mathematics In a room, there are N people, and they want to do a handshake. How many total handshakes will happen? Answer: n * (n - 1) / 2 -> Combinations

Question 5 - SQL We have 3 tables:

• Employee: emp_id, dept_id, emp_name
• Department: dept_id, dept_name
• Salary: emp_id, amount

I want to find the details of the department with the 2nd highest salary.

Question 6 - SQL We have 1 table:

• Salary: emp_id, amount

I want to find the 2nd highest salary amount from this given table. NOTE: I cannot use any window functions, nor can I use LIMIT and OFFSET.

2nd Round

1st Question - Java What is method overriding? Are you using OOP concepts in your regular routine? Can you give some examples where all the concepts are used?

2nd Question - Java Are you familiar with Multi-Threading? Do you have any idea about ExecutorService? I want to design an ATM using ExecutorService where multiple users can withdraw money simultaneously. However, we need to take care of the money available in the ATM such that if no money is available, the user won't be able to withdraw. Also, for simultaneous users, it needs to be synchronous.

3rd Question - Java We are given a string. I want to find the maximum distance between two repetitive words. String str = "Hello Param Welcome to Oracle Param is from Ahmedabad Param is Java Developer"; Among this, the distance between "Param" keywords has the highest distance between its first repeated iteration and last repeated iteration.

There was one more question asked in this round, but I forgot its definition.

3rd Round

Question 1 - Java We are given a string in the date format dd-mon-yyyy and an integer n. We want to design a Date Adder function without using any date functions available in Java. Example: String date = "09-May-2025", int n = 30; It should return "08-Jun-2025". Also, it should account for leap years.

Question 2 - Java Find the longest common prefix from the given array of strings. Example: String[] arr = new String[] { "automatic", "auto", "autonomous" }; Answer: "auto"

Question 3 - Java Traverse a matrix in a stepping order with m * n dimensions. Rules:

• If you are reaching the last step, you cannot override the step.
• If you have reached the last step and are fulfilling the 1st condition, you have to come back home using the last row and the 1st column and print the steps you've covered.

Example: We have one matrix of 4*4 [1, 2, 3, 4] [5, 6, 7, 8] [9, 10, 11, 12] [13, 14, 15, 16]

I'll start traversing from (0,0). Result will be like this: 1, 2, 6, 7, 11, 12, 16, 15, 14, 13, 9, 5

If it were a 4 * 3 or 3 * 4 matrix, it would not be possible to traverse the reversal (last row and first column).

Question 4 - Puzzle Find the winner of a Table Tennis game based on the following conditions. Details:

• 3 Players are playing a table tennis game.
• Player 1 played 8 matches.
• Player 2 played 12 matches.
• Player 3 played 14 matches.

Rule:

• If any player wins a match, they continue playing, and the opponent is switched.

Additional Info:

• Player 2 won the last 7 matches continuously.

This was my overall experience at Oracle India at the Gandhinagar Development Center.

Overall, the experience was very good and highly interactive.