Oracle Job interview Experience
pic
Saiteja Kalakuntla
Profile
IT Product
CTC/Stipend
Login to view this
Criteria
Login to view this
Session
2021-22
Status
Accepted Offer
Round 1

Computer Based Test Interview

Time
90 mins
Difficulty
Medium
Interview Experience

This round was MCQ based round. There were 4 sections and each section was further divided into subsections. Some of the sections were Aptitude, Attention to Details, CS fundamentals, Programming MCQs, Flowchart based questions(Understand the logic of the question and then start answering mcqs). There was no negative marking so you can attempt all questions.

Round 2

Technical Interview

Time
60 mins
Difficulty
Easy
Interview Experience

The interview started with my introduction, and then he asked about my summer internship project which I did in spring framework. He asked some annotations used in my project, then he asked on @Autowired annotation. I have used SQL in my project so he asked what type of queries were used in my project. Then he moved to DBMS and asked what are transactions, ACID properties, indexes and their types. Then he asked which language do you prefer and asked differences between C++ and Java. At last he gave a coding question, find all the unique elements in the array. First I gave a map based solution, then he asked to optimize space complexity. I gave him a solution based on condition, all array elemnts are positive and are in a given range. He was satisfied with my solution.

Round 3

Technical Interview

Time
60 mins
Difficulty
Medium
Interview Experience

This round also started with my introduction and he quickly moved to my resume. He asked all the 3 projects mentioned in my resume in depth. Then he asked about client-server architecture. He asked about session management. Then he asked, whenever a user logins with his id and password and requests for many services (like check balance, check history etc in case of a banking web app) how does the server validate input request everytime whenever a user sends, whether it is coming from a valid user or not? (Answer was based on sessions) Then he asked about hashing and real time applications of hashing. Then he asked what was my fav subj. I replied data structures and maths. Then he asked question on maths, what is the difference between hyperbola and parabola and he asked the definition of a circle.

Additional

Other comments

Make sure you know each and every project mentioned in your resume and be ready for the follow-up questions. Be thorough with DBMS concepts. If you need time to think for a solution, always ask interviewer for it.