Oracle Interview Experience for Full-Time MTS (On-Campus)
Oracle visited our campus to hire Final year students for MTS and Application Engineer profiles.
Round 1 (Online Test): This round was of 107 mins duration. The test contained several sections and all questions were MCQs. The sections were Coding ability, Computer Science theory, Advanced data structures like AVL Tree, Verbal and Quantitative ability, etc.
Around 40-45 students were shortlisted for each profile for further process.
Round 2 (Technical Interview 1 for 30 mins): The interview was being conducted over the Zoom Platform.
- This round started with an introduction to both myself and the interviewer.
- He then asked a few questions about my internship project. Then he moved on to coding question. The question was simple enough as only a Level Order Traversal of Tree was required.
- I had to write a full working code on a shared coderpad. Where he ran a few test cases also. He was satisfied with the code.
- Then he asked me if I knew Databases. I said yes and then he asked me to write 2 queries. The two given tables were:
- Student: (sid, sname)
- Coursed: (cid, cname)
He said that any number of students can be enrolled in any number of courses. I had to model a relationship and then write the following queries:
Find the number of students enrolled in each course.
Find the course in which max students are enrolled.
I first introduced a new table -> Enroll: (sid, cid) and then wrote the queries:
Select cid, count(sid) from enroll group by cid
Select cid from enroll group by cid order by count(sid) desc limit 1
He asked a few questions about the queries and then the round was done.
Round 3 (Technical Interview 2 for 30-40 mins): First, both of us introduced ourselves and then he jumped straight to coding questions. I had to write working codes on a shared Coderpad again.
- The first question was simple enough, I had to print the reverse of a given string. He asked me to do it using a stack.
- The second question was also a standard DP ques, Print LCS of two given strings.
He asked me if I know what this problem is by its name. I said I can figure it out by seeing the name itself. He said okay and write the code and explain the approach. I wrote an iterative DP code for the same.
He then started asking about Microprocessors. I answered a basic question and then told him this is not my comfortable domain so please ask something else.
He then asked from networking and asked me to explain all the layers of the OSI model.
This concluded the round.
Round 4 (Managerial Round for 30-40 mins): This round was basically a mixture of Behavioral and Technical questions. The interviewer was a Senior Engineer Manager at Oracle.
- Starting with introductions, he asked what my favorite subject was. I replied Algorithms. Then he asked me to tell him a few algorithms which I found most interesting as well as challenging learning.
- I told him about Dijkstra Shortest Path and Kosaraju’s SCC algos.
- He then asked me about my academic project and the team making process in detail. He also asked who decides work distribution in the team and whether there was a time in the team when somebody worked less or somebody worked more than expectations and some other questions like this. The key is to be open and confident here and sound like a team player.
- Then he moved onto some technical portion and revisited my queries from round 1. He asked me whether they will work for very large datasets and if they will work will these be efficient? If not, then how to make them efficient.
- I was not sure what answer he was expecting from this, so I started discussing the problem with him. We discussed the background working of these queries and then I got an idea he wanted “Indexing” so that’s what I told him.
- Then he moved on to my hobbies section on my resume. I had listed Stock Markets there, so he asked me to give him a few tips to make quick money. I explained to him how this “quick money” in itself is a wrong approach to making money in stock markets unless you know what you are doing.
The interview ended here. He seemed satisfied with the round and so was I. They were running out of time, so I doubted whether my final HR round would take place or not as for some candidates it had taken place.
Round 5 (HR Round for 10 mins Group Round): As they were running short on time, the HR round was being conducted in groups. It was more of a casual conversation rather than an interview.
Some standard HR questions were asked like:
- What research have done about Oracle before applying
- What is Oracle to you in one word. (Not Database) etc
The process was going on for the whole day and we were continuously online either in the interview or in a Zoom waiting room. So it was hectic. The results were announced the same night.