Oracle | SDE-1 | On-campus | Rejected

ORACLE INTERVIEW EXPERIENCE

Position : Application Developer

Coding Round :

The online assessment contained few aptitude questions , 2 easy DSA questions and one REST-API related question on 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 a HBO documentary on nuclear plant disaster in Chernobyl.

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 https://www.geeksforgeeks.org/puzzle-15-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 doesnt load properly

There were some technical questions as well like -

Regarding REST APIs
Some IP protocols
OSI Model
Utility of Transport Layer
The requirement of Normalisation
Explain the types of joins
Some questions related to Virtual Memory as well
SDLC

I couldn't answer the last question only. But I soon realised why he did ask that tho, because his team worked with DevSecOps which required continous 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 inital 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 https://www.geeksforgeeks.org/puzzle-6-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