 |
VOOZH | about |
|
VOOZH | about |
Oracle visited our campus for two roles: Application Development and Server Technology. The coding round was conducted on hackerrank platform.
The online assessment contained 36 questions. Out of which some questions were aptitude questions, some technical question, some reading comprehension and verbal ability questions and 1 DSA question of medium level.
After this round around 26 students were selected for interviews for application developer role. I was among them.
Interview started with my brief introduction. After the introduction he started with the DSA questions. First question was
Given a string of digits and a specific digit 𝑘.write a program to find the largest number that starts with the digit 𝑘. For instance, if the string is "12345678" and 𝑘=5. The output should be "5876321".
I was able to solve this question and then he moved to next question that was:
Given the array of strings S[], you need to find the longest string S which is the prefix of ALL the strings in the array.
I was able to solve this question but he asked me to optimize it which I was not able to do. Then he moved to my project. He asked me functionalities of my project along with some JavaScript questions which I was able to answer. He also asked me why did you choose MongoDB as database as my project was based on MERN.
Round 1 got over.
Verdict: Selected for Round 2.
The interviewer was quite friendly and he asked me not to call him sir rather than call him by his name. But I continued to call him sir.
He introduced himself and gave me an overview how will he take my interview. So he started with DSA.
He asked me about heap sort, how it is implemented and even asked me to write the pseudo code for it and explain with example. I was able to do that then he moved to next DSA question that was to make matrix row and column sorted. This was quite an easy question and I was able to do it properly.
Now he moved to next question that was to explain Dijkstra's Algorithm using real life example. I was able to do that too.
After this he gave me a standard puzzle: https://www.geeksforgeeks.org/aptitude/puzzle-9-find-the-fastest-3-horses/
I had already seen that so i was able to do it.
Now he started deep diving into my project asking about design patterns and miscellaneous stuff regarding my project. I was able to answer those questions and interviewer was quite impressed with that.
Round 2 got over.
Verdict: Selected for Round 3.
In this round, interviewer was quite senior one having 12-13 years of experience working at Oracle. He made me wait for 5 mins as he was busy with some work.
After 5 mins, interview started and he asked me about normalization in DBMS (why do we need normalization) and asked me to explain BCNF with example. I was able to answer this but I got stuck in explaining the example of BCNF. But he was ok with it.
After this he moved to my ML project mention on my resume and asked me to explain it.
Now he asked me about difference between SQL and NoSQL databases and asked me which is better in what situations . He tried to confuse me with that but I managed to answer it well and he was impressed with that.
After this he asked me basic SQL query to find 2nd highest employee from employee table.
Now he asked me to describe situation where I have shown leadership skills and also asked me situation where I had clashes with my teammates. This was quite normal discussion.
And lastly he asked me whether I have anything to ask him and the interview concluded.
Verdict: 5 people got selected for the application developer role and I was one among them.
