Oracle Interview Experience -On Campus (2019)

The shortlisting for rounds are done by an online test held for approximately 2.5 hrs with 90 questions(MCQ). There are 4 sections, First one has questions on trees mostly AVL, RedBlack, Second section has Quant aptitude questions, Third one has questions on Data Structures and Algorithms, DBMS, CODD, CN, OS and Last were english and verbal skills apti questions.

After the online test ~110 students were shortlisted out of 250 students .

Round 1:

Interviewer scanned my resume and then asked me whether i know chess and then design chess game using OOPs concepts.

He asked me about inheritance, polymorphism, abstract class, encapsulation, when to use interface and abstract class.

Some coding questions were asked similar to this:

https://www.geeksforgeeks.org/maximum-sum-such-that-no-two-elements-are-adjacent/ 

https://www.geeksforgeeks.org/equilibrium-index-of-an-array/

https://www.geeksforgeeks.org/find-the-maximum-sum-path-in-a-binary-tree/

Difference between port and socket.

Design a Library Management System and then based on my design he asked me to write a query to find the books which are not issued and present in Library.

Round 2:

This round was again on Data Structures and Algorithms.

https://www.geeksforgeeks.org/calculate-angle-hour-hand-minute-hand/

https://www.geeksforgeeks.org/sort-elements-by-frequency/

https://www.geeksforgeeks.org/check-if-two-strings-are-permutation-of-each-other/

Interviewer wants most optimized code for all questions.

Puzzles were asked similar to:

https://www.geeksforgeeks.org/puzzle-12-maximize-probability-of-white-ball/

https://www.geeksforgeeks.org/puzzle-4-pay-an-employee-using-a-gold-rod-of-7-units/

Round 3:

In this round Interviewer gave us some quantitative aptitude questions (CAT Level) which we have to solve in front of him.

Questions were similar to :

https://cat.wordpandit.com/cat-percentage-questions/

Round 4:

Interviewer starts with my interest in computer science and then later asked me about my project. Deep discussion on project. What was difficulty faced.How I overcome it.

As my projects were on Android App and Desktop App. He asked me to draw class diagram, ER diagram.What is Api, How I am ensuring security etc.

One coding question was asked:

https://www.geeksforgeeks.org/find-the-smallest-positive-number-missing-from-an-unsorted-array/

It must be in O(n) time and O(1) space.

Round-5 HR Round

1.Why Oracle?

2.My future Goals.

3.About Higher Studies.

4.Do you consider yourself Successful.

5.Strengths and Weakness.

Tips:

Go through All Archives of Oracle from Geeks For Geeks. Almost every thing is present there.

The most  important thing is to stay calm and confident and answer the question with accuracy as possible .

Total 27 students were selected and I was among them 🙂