Oracle Interview Experience (On-Campus) 2024

Position: Application Developer

Coding Round :

The online assessment contained a few aptitude questions, 2 easy DSA questions, and one REST-API-related question on the hackerrank platform.

Technical Interview :

Round 1

I introduced myself to the interviewers, a normal introduction (I also mentioned my fondness for web series :p ) and the interviewer caught me by surprise and asked me which recent web series I had watched. I talked about an HBO documentary on the nuclear plant disaster in Chornobyl.

Ok back to all seriousness, there were questions on

• Inheritance (based on diamond problem)
• Inheriting base classes in private, protected, and public mode
• One puzzle similar to the Camel and Banana puzzle
• Why doesn’t Java support Multiple inheritance and stuff

I was asked if I have i had any questions. I asked him how do you guys handle synchronization between distributed databases. He liked my question and eventually explained the whole system behind maintaining such a sophisticated cloud platform provider.

Round 2

This round was a long and one of my favourite rounds. The interviewer was cool and asked for my intro. He asked some stuffs regarding my projects which included

• What shall you do if your webpage doesn’t load properly

There were also various technical inquiries, including like-

1. Regarding REST APIs
2. Some IP protocols
3. OSI Model
4. Utility of Transport Layer
5. The requirement of Normalisation
6. Explain the types of joins
7. Some questions related to Virtual Memory as well
8. SDLC

I couldn’t answer the last question only. But I soon realized why he did ask that tho, because his team worked with DevSecOps which required continuous development , deployment and monitoring cycles while not keeping security in the hindsight.

Well at the end of this round, I asked him that oracle deals with several latest innovations like IoT, ML, AI as well. So as I a fresher what do I expect to be working upon in the initial days. He liked my question and answered that they would assign me to the DevSecOps team lest i be selected.

Round 3

This round was taken by the Vice President of Oracle himself. He asked for my general introduction and he was very sensible and nice guy.

He asked me the famous puzzle Monty Hall problem

He asked me one DSA question on how do I find a loop in a tree. I explained him a general DFS approach.

He also asked me for the pseudo code for DFS and BFS.

Also he questioned why do you need normalisation and why is there sometimes a need for denormalisation as well.

So that was it…

My interview was finished at around 3pm but my rejection news came around 8.30pm (T_T)

My take from the interview : Please don’t neglect the HR questions. They too can become a core decider in your selection probability even though the technical interview itself was no brainer.

Final verdict : Rejected