Placement Papers - ORACLE

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 were total 4 rounds :

Round 1: WRITTEN ROUND.

It was an online MCQ round for around 120 minutes. Exam was mainly divided into 5 sections:
Aptitude.
Coding skills.
English.
CS core subjects questions (OS, DBMS, DS).
Software Engineering .
From around 800 students 40 were selected.

Round 2: TECHNICAL INTERVIEW 1.

My interviewer was really supportive and kind.
He asked me to code for questions given below:

Q1. Find which mechanic is nearest to the user according his current location. This was typically a Geocoding related question which was a part of my ongoing project.

Q2. Group the anagrams from the list of Strings
ex: [cat, tca, perk, prke, tac]
O/P: [cat, tca, tac], [perk, prke]

Q3 . print the left view of the tree

Round 3: TECHNICAL INTERVIEW 2.

Q1. Which data structure should we use to make phone dictionary.

Q2. Model a system of doctor and patient records so that there is no redundancy in the table. (DBMS related question).
Round 4: HR CUM TECHNICAL ROUND .

Q1. Asked which Operating System I use then bombarded 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 in your laptop.

Q2.  If you ping to Google from your laptop and it fails then how will you troubleshoot this problem.

Q3. Speak for about 1 minute on any topic of operating system.

Q4. What do you know about Oracle. Goal of life and some other hr related questions.

And the interview ends here.....
Interview started at 10 A.M and ends at 4:30 P. M with half an hour break for the lunch.