Oracle Interview Experience for 2 years Experienced

I interviewed for Oracle in the month of August for the team Oracle Application Labs (OAL) for location Bangalore, Hyderabad and Pune.

Round 1 (Online MCQ): The first round was online MCQ round which comprised of  questions related to quantitative aptitude, logical reasoning and technical topics like Data Structures (majority questions were based on tree), OS, DBMS and Computer Network. The main concern was time constraint. There was no negative marking.

After a week I received a mail to come at the Noida office for face to face interviews.

Round 2 (Technical Interview):

1. Asked questions about one of the projects I mentioned in my Resume. My contributions to the project.
2. https://www.geeksforgeeks.org/reverse-individual-words. Asked to write the code on paper.
3. https://www.geeksforgeeks.org/program-to-find-whether-a-no-is-power-of-two. I gave the interviewer the iterative approach but the interviewer was expecting the answer using bitwise operators. The interviewer gave me some hint to proceed with the same.
4. Write SQL query to find the number of employees in each department along with the department name.
5. https://www.geeksforgeeks.org/puzzle-blind-man-and-pills
6. A cube of dimensions 4 x 4 x 4 is painted with black colour on all faces. Then the cube is cut into smaller cubes  of size 1 x 1 x 1. How many smaller cubes are not painted at all?
7. https://www.geeksforgeeks.org/puzzle-4-pay-an-employee-using-a-gold-rod-of-7-units

Round 3 (Technical Interview):

The interviewer asked to interview myself and then asked questions related to the projects.

1. Given two buckets of capacity 3L and 5L, measure 4L of water using them. There are two solutions asked for the problem. The interviewer asked both the solution.
2. Object Oriented design for Post paid System.
3. Given a table, remove duplicate entries from it.
4. https://www.geeksforgeeks.org/puzzle-mislabeled-jars.

Round 4:

1. Detailed discussion about the project.
2. Given a sequence: 1, 3, 13, 183. Find next number in the series. Solution: 33673The logic behind the sequence is as follows:1  =  0 x 1 + 1,  the first number in the series2 = first number x (first number +1) + 1, second number in the series3 = second number x (second number +1) + 1, third number in the series
3. Why do you want to join Oracle?