ORACLE conducted pool campus at CET, Trivandrum.So my college was one of the 5-6 college chosen for participating.The process is as follows:
Step1:
The step one was online test conducted by ORACLE in their platform.The question was divided into
1)Quantitative aptitude and Logical reasoning
2)Data structures and algorithms
3)General CS subjects
4)English and vocabulary Each of the section was allotted some time and the time was total 90 minutes which is equally divided between each of them.Quantitative aptitude was medium to hard questions which is not seen in normal service company tests..Logical Reasoning had 2 flow chart based questions which required high level of understanding and analyzing complex flowcharts other than many data interpretation questions.Data structures and algorithms had many questions mainly from Red Black trees,binary trees,AVL tree and insertion or deletion and traversal of these trees.Also there was a section on a single topic which was different for all, mine was based on Radix sort.Although there was no coding part, all questions were based on finding output or choosing the correct code for a particular task like left rotation in AVL trees etc.Third part of general CS subjects had questions covering from core CS subjects like OS, DBMS, C++ output based questions with importance towards pointers and variable declarations.Last English questions was simple and included grammar correcting ,paragraph comprehension,reordering of sentences, vocabulary, etc
around 35 students cleared it from out college (TKM College of engineering ,Kollam) and around 20s-30s from other colleges. Step2:
The above results were given before two days of interview so i had only two days to prepare for interview as i had already got offer from TCS digital and was not doing any preparation after that.The interview was held at CET,Trivandrum.
I had total 5 rounds including HR and each round where the following :-
FIRST ROUND
2.1)i was asked 2 Easy coding questions-2.1.1) second largest number in O(n). 2.1.2)Stock buying problem in O(n). puzzles included 25 horse race,single torch and bridge puzzle,finding the defective item in 10 containers puzzle.Few questions on python,bs4 and pyc,because i mentioned in my resume.I answered all of them and i felt i impressed them.
SECOND ROUND
It was system/database design round where i was asked to construct a database schema for online tailoring shop with various requirements.What i answered was not the answer he was expecting and was not satisfied.He asked me to explain about my project.In the end he asked about 3 ants in equilateral triangle puzzle which i answered.
THIRD ROUND
It was basically a stress interview and was taken by some senior employee/manager.He asked me a coding question to be done on paper -in 2D matrix i needed to find the count of occurrence of “ORACLE” word in it which can occur in any manner downward upward or diagonal etc. I solved it using DFS based backtracking,Although it had very minute mistake he was impressed by the quickness of implementation of algorithm and coding.He asked to implement database schema for relief camps and kept on increasing its complexity and requirements.I answered most of them.He then asked basic question from IOT,serverless computing,cloud computing,difference between NOSQL and SQL and mongodb and SQLite. I could answer almost all of them vaguely.He then asked what is “friend” function in C++ which i could not answer.
FOURTH ROUND
it was a short interview.He asked me to code printing matrix spirally and gave very less time (around 5-7 minutes).He then asked how to optimize it.He asked basic questions like why ORACLE and my projects.
FIFTH ROUND
This was the HR round.She first asked me how was my interview and then asked me to explain about my resume.She asked about my family and asked what i know about products of ORACLE and other general HR questions.She also asked about what all interview i attended and what all i offers i got.It ended normally. RESULT:
Got the offer