Oracle Interview Experience - Online Interview, 5 October 2020
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.
Companies List:
3i Infotech - AAI - ABACUS - ABB - Accel Frontline - Accenture - Aditi - Adobe - ADP - Agreeya - Akamai - Alcatel Lucent - Allfon - Alumnus - Amazon - Amdocs - AMI - Andhra Bank - AppLabs - Apps Associates - Aricent - Ashok Leyland - Aspire - Atos Origin - Axes - Bajaj - Bank of Maharashtra - BEL - BEML - BHEL - BirlaSoft - Blue Dart - Blue Star - BOB - BPCL - BPL - Brakes - BSNL - C-DOT - Cadence - Calsoft - Canara Bank - Canarys - Capgemini - Caritor - Caterpillar - CDAC - CGI - Changepond - Ciena - Cisco - Citicorp - CMC - Consagous - Convergys - CORDYS - Crompton - CSC - CTS - Cummins - Dell - Deloitte - Delphi-TVS - DeShaw - Deutsche - Dotcom - DRDO - EDS - EIL - ELGI - ELICO - ERICSSON - Essar - Fidelity - Flextronics - Freescale - FXLabs - GAIL - GE - Genpact - Geodesic - Geometric - Globaledge - GlobalLogic - Godrej - Google - Grapecity - HAL - HCL - Hexaware - Honeywell - HP - HPCL - HSBC - Huawei - Hughes - IBM - IBS - ICICI - iGate - Impetus - iNautix - Indian Airforce - Indian Airlines - Infosys - Infotech - Intec - Integra - Intergraph - IOCL - iSOFT - ISRO - Ittiam - JSW - Keane - Kenexa - L & T - L & T Infotech - LG Soft - Lifetree - LionBridge - Mahindra Satyam - Mastek - Maveric - McAfee - MECON - Microsoft - MindTree - Miraclesoft - Mistral - Motorola - Mphasis - MTNL - NIC - Nokia Siemens - Novell - NTPC - Nucleus - ORACLE - Patni - Perot - Polaris - Ramco - Robert Bosch - Samsung - SAP - Sapient - Sasken - SBI - Sierra Atlantic - Sonata - Sony India - Sutherland - Syntel - TCS - Tech Mahindra - VeriFone - Virtusa - Wipro - Zensar.