Recently Oracle visited Banasthali Vidyapeeth for hiring FTEs of 2021 batch and interns of 2020 batch for the position of Member of Technical Staff (Server Technology). Although I didn’t get selected for the position but reached the final stage of the interview. So, thought to share my experience to help all the Freshers and interns whoever is aspiring for ORACLE
There was a total of 4 rounds :
Round 1(Written Round): It was an online MCQ round for around 120 minutes. Exam was mainly divided into 5 sections:
- Coding skills
- CS core subjects questions (OS, DBMS, DS)
- Software Engineering
From around 800 students 40 were selected
Round 2 (Technical Interview): My interviewer was really supportive and kind. He asked me to code for questions given below:
Find which mechanic is nearest to the user according to his current location. This was typically a Geocoding related question which was a part of my ongoing project.
Group the anagrams from the list of Strings
Input: [cat, tca, perk, prke, tac] Output: [cat, tca, tac], [perk, prke]
Round 3 (Technical Interview):
- Which data structure should we used to make a phone dictionary?
- Model a system of doctor and patient records so that there is no redundancy in the table. (DBMS related question).
Round 4(HR + Technical):
- Asked which Operating System I use then bombarded with many questions related to RAM, IP address, how can u see your computer’s IP address, what are the other things that are mentioned with the IP address on your laptop.
- If u ping to Google from your laptop and it fails then how will you troubleshoot this problem.
- Speak for about 1 minute on any topic of the operating system.
- What do you know about Oracle? The goal of life and some other hr related questions.
And the interview ends here…..
The interview started at 10 A.M and ends at 4:30 P. M with half an hour break for the lunch.