Oracle Job interview Experience
pic
Harshal Deshpande
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 conducted on Oracle's platform with camera proctoring. Approximately 90 questions were asked in 3 sections and each section was further divided into subsections. Some of the sections were Programming MCQ'S (questions were from tree traversals, AVL trees, radix sort, etc.), Operating systems, DBMS, Complete flowcharts (basic algorithms), Critical thinking, Maths, Logic, etc.

Round 2

Technical Interview

Time
30 mins
Difficulty
Easy
Interview Experience

Focus of the interviewer was on my projects and internship. Specific questions related to the choice of tech stack(for projects), detailed discussion and cross questions on my internship project were asked. Some OS questions (What is 2 phase locking, etc.). Simple coding question at last (Find non repeating element in array in O(n) time and constant space) Ans- XOR. Approach + Code(Language and IDE of my choice)

Round 3

Technical Interview

Time
30 mins
Difficulty
Medium
Interview Experience

2 coding questions were asked of which first was easy and second medium
Language and IDE of my choice
Interviewer expected a fully working code rather than a function.
1) Sum up all instances of of repeating elements in array and print those whose sum exceed 100.
eg:- arr = [10, 50, 10, 50, 25, 100, 50] Output:- 50
2) Find most recurring contiguous substring(min 2 elements) in given string.
eg:= str= "AbRat33Rat4545A454545" Output:- 45

Focus was more on choice of Data structures rather than time complexity.

Round 4

Technical Interview

Time
60 mins
Difficulty
Difficult
Interview Experience

Round started with 10 to 15 questions on OS (Belady's anomaly), DBMS (Transaction management), Computer Networking (Classless IP addressing, subnetting, NAT, BGP) many more...
SQL vs NoSQL databases.
Why did I choose NoSQL in my projects?
What is the future of RDBMS?
Why would a company prefer RDBMS?
What is autonomous database? (this was told in pre-placement talk)
What is CORS, when CORS error occurs and how to fix it?
Many more questions on personal and internship projects.
Puzzle:- Given X teams in a tournament. Each team competes with all other teams twice. Either win/loose no draw situation. Minimum wins required for a team to qualify.
Interviewer expected a solution with dry runs, edge cases and working code. (Go through popular puzzles on GFG)