Oracle Interview Experience for Full-Time MTS (On-Campus)
Last Updated :
29 Sep, 2020
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.
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.
Verdict: Selected.
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...