Oracle Interview Experience For Internship 1

Some helpful Interview Tips in the end!

Oracle visits our campus annually and recruits approximately 15 individuals each year.

This is what the process looks like:

1️⃣ Campus placement department shared the form for registration.

2️⃣ Preliminary online coding round.

3️⃣ 3 technical interview rounds.

4️⃣ 1 HR interview round.

The campus placement department shared the form for registration.

The Placement Department (TPO) provided us with a Google form for company registration. There was a minimum criteria from the company – CGPA 7 or equivalent to 70% & above, no standing arrears. The branches allowed by the company were B. Tech/M. Tech/Dual with specialization in CSE/ECE/EEE/IT (CS/IT & Circuit branches).

Preliminary online coding round.

The first round was an online coding round. It had around 20 MCQs (10 aptitude + 10 English) and 2 coding questions. I found the MCQs to be straightforward. The coding questions were different for everyone. The first one was easy to moderate. The second was moderate to difficult. I could solve one question completely and the other one I cleared 8/10 test cases.

Results: Around 74 people were selected for the interviews.

Three technical interview rounds.

1st Technical Round

I started with my introduction. Spoke about my previous internship experiences and projects made till now. Then he asked basic DSA questions. One of them was finding a loop in a . Another was: Given an array of n-1 elements, find the missing number in the array. He was satisfied with my solution as I started with a brute-force solution and then moved on to a more optimised solution.

Then he asked me a puzzle. He said that I had a 2-hour glass, one of 4 hours and another 7 hours, and I had to make 9 hours with that. I took some time but solved it.

This round lasted about 50-55 minutes and set the foundation for the upcoming rounds.

Results: About 40 – 45 students were selected for the second round.

2nd Technical Interview:

The interviewer asked me to introduce myself. I presented an overview of myself, taking some time to talk about the languages I know, as well as my projects and internship experience. He then posed a fundamental question about substring and slicing in Java, providing a spontaneous random string. He instructed me to extract a specific substring from the given string. He only wanted to know if I knew how to do it. Next, the interviewer asked me a question in JavaScript(flexibility was given to choose the language) to calculate the difference in time between the creation of a file and the present time. Again he only wanted the approach and not the actual solution.

The interview lasted around 40 minutes where the interviewer touched upon basic concepts of OOPS and a little about DBMS as well.

Results: Around 30 students were selected for the third round.

3rd Technical Interview:

In the third round, the focus shifted towards conceptual aspects. The interviewer initiated queries related to the operating system, such as distinguishing between Multithreading and Multiprocessing. Subsequently, the discussion delved into in-depth questions about Object-Oriented Programming (OOPS), where I was asked to elucidate certain concepts with code on a notepad. The interviewer also posed questions about Cloud Computing and Software Design Patterns (OOADP).

In summary, the third round proved to be the briefest yet most challenging. It demanded a comprehensive understanding of all core subjects.

Results: Around 20-24 students were selected for the HR round.

Takeaways: Know the basics, and be confident, the introduction serves as the pivotal element that propels the interview forward, and include good projects in your resume.

HR Round

The fourth round comprised the HR interview, during which the interviewer inquired about basic introductions, interests, hobbies, and CGPA. In cases of a lower CGPA, the interviewer might inquire about the reasons behind it and the strategies in place for improvement. Common HR interview questions were posed, including inquiries about future aspirations, plans for further education, and discussions on strengths and weaknesses.

Results: The outcomes were disclosed within 2-3 days following the interviews, and a total of 19 individuals from my college were chosen in this round.

Takeaways: Speak with confidence, prepare for frequently asked HR questions before your interview, and maintain a good CGPA.

Oracle conducts all interviews virtually, with all four rounds taking place on a single day through Zoom. The interview sessions commenced at 10 am and extended until 9 pm. Your patience is appreciated during this process.

Few tips for a successful interview:

1. Clarify any doubts before you begin coding.
2. Prioritize getting the correct solution initially, then concentrate on optimization.
3. Communicate your thought process during the interview.
4. Pay attention to leadership and behavioural questions; don’t overlook them.
5. Speak with confidence about your experiences and responses.
6. Possess in-depth knowledge about your projects.
7. Master one programming language and solve Data Structure and Algorithm problems in that language.
8. Acquire a good understanding of core subjects such as DBMS, OOPS, Computer Networks (CN), and Operating Systems (OS).

Oracle-specific tips:

1. Java proficiency is preferred.
2. Demonstrate a strong grasp of Object-Oriented Programming (OOPS) and Database Management Systems (DBMS).
3. Practice SQL queries to enhance your skills.
4. Familiarize yourself with the technology stacks utilized in your projects.

Verdict: Selected