Oracle visited our campus to hire Final year students for MTS (server Tech) and Application Engineer profiles.
ROUND 1: ONLINE TEST
This round was of 107 mins duration. The test contained several sections and all question 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 (30 mins)
The interview was being conducted over Zoom Platform.
- This round started with an introduction of 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:
- 1. Student: (sid, same)
- 2. 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
- He asked a few questions about the queries and then the round was done.
ROUND 3: Technical Interview - 2 (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.
- First question was simple enough: I had to print the reverse of a given string. He asked me to do it using a stack.
- 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 OSI model. This concluded the round.
ROUND 4: Managerial Round (30-40 mins)
This round was basically a mixture of Behavioral and Technical questions. Interviewer was a
Senior Engineer Manager at Oracle.
- Starting with introductions, he asked what my favourite subject was. I replied Algorithms. Then he asked me to tell him a few algorithms which I found most interesting as well as challenging to learn.
- 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. 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 or not 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.
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 (10 mins) (Group Round)
As they were running short on time, 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.
Verdict: Selected
Samyak Jain
Comments
Post a Comment