Oracle Interview Experience | Full Time for Server Technology (On-Campus)
1st round: MCQ Test Round(online)
The test was divided into four sections:
Mathematics(probability, equation based),
Observation(You just had to tell which of the 4 options was present in the above given 10×3 table just by looking and observing),
Flowchart(a flowchart for a given situation was given, and some conditions(standard diamond shaped boxes) were empty. You had to tell which option fits which of the conditional boxes. There were 3,4 questions on the same flowchart, so properly studying the chart could help you answer all the associated questions).
(ii) Coding Output Based:
Most questions were based on predicting output of the given code snippet( There were a lot of questions from Trees(any sub-topic)),
Some complexity based questions.
(iii) Core Subjects:
Fundamental(most) and tricky(few) questions from OS, DBMS, OOPS.
(iv) English Comprehension:
Unseen passage based questions,
Grammar based questions,
Ordering the sentences in a meaningful order,
best synonym substitution based questions.
A lot of practice is needed to solve this section. You have to maintain your speed throughout the test.
2nd Round: Coding Round
They will ask you for your preferable language for coding. You can choose any language with which you are comfortable.
You have to write the whole code from inputting to printing output. They will provide you the link of coderpad and then you have to code there. They will run the code when you are done with it.
3rd Round: Technical Round
The questions started from OOP concepts:
(i) Constructors and Destructors
(ii) Purpose of Destructors
(iii) Why Destructor is used when delete is there?
(iv) Operator Overloading
After this he asked my favorite subject to which I replied Databases. Then a series of questions were asked from this.
(ii) ACID properties
Since I am master’s student they asked me what new I can think to apply in Databases.
They gave me a hypothetical situation that I am an Oracle employee working on cloud and he is the client. How can I keep his data safe in case of some failure?
To this I answered, we can keep user’s data at different places so that when failure occurs loss is minimal. Or we can create replication of data and keep it at some other place.
4th Round: Technical Round
The interviewer started with clouds, if I knew anything about it.
I simply said No, I never worked on it.
He asked if I can think of any method where I can reduce computational complexity.
I answered in context of my project where I ran a deep learning pre-trained model on my laptop by creating bottleneck features.
He was a bit impressed with my project. He asked the datasets which I used and the accuracy.
Next he said he wanted something in terms of system design so he asked to imagine a situation where I have to make robot drive a car. How will I do it?
I told we can apply object detection to find the objects and also a moving hardware so that robot can drive itself. It should have a software for traffic rules and also should have a camera to recognize objects.
But I think he wanted to hear something else.
He asked how will the robot reach to the car. He gave me a hint I can apply Graph Theory.
I instantly said we can apply Dijkstra.
After this he was very impressed.
He asked what is Dijkstra Algorithm and started telling he has also applied this algorithm in many networking projects.
Not a round : Just a discussion
HR asked what I know about Oracle.
Verdict : Selected
P.S. – My last piece of advice is be honest with the interviewer about what you know. Keep your mind in super active mode in system design type of questions.
Thanks to GeeksForGeeks for such an amazing content and preparation material