Oracle Interview Experience For Application Developer (On-Campus)
Oracle On-Campus Placement for the role of Application Developer for Freshers and Past Experience: SDE Intern at Zepto
Round 1:
- Given a string, print all permutations of that string that are greater than it.
- Knapsack Dp question
- Have you used Oops in an internship? (I explained singleton class and wrote code)
- Basic oops questions?
Overall difficulty: Easy
Round 2:
- Given the birth and death years of N people. Find the year with max population.
- Given a grid having 0, 1, and -1 (0 and 1 for score, -1 = trap). You have to reach from 0,0 to n-1, having a max score. You can travel in all 4 directions
- Asked about internship experience and tech stacks used.
- Asked in-depth questions related to personal projects (Chat application with video and voice calling feature). Asked why you had used this tech stack. Gave me 2-3 new features to implement.
- Design a Hotel Booking System (high-level design and schema design)
Overall difficulty: Medium – Hard
Round 3:
- Asked about internship experience
- System design round – Implement Book My Show from UI to backend(APIs and Geolocation feature)to schema and DB design.
Overall difficulty: Hard (interviewer was very strict, tried to point out as many mistakes as possible)
Round 4 [Hr + few technical ques in OS and DBMS]:
OS:
- Concurrency vs parallelism?
- What is a deadlock? Necessary conditions for deadlock to occur?
- Deadlock avoidance, prevention, removal etc. What is RAG?
DBMS:
- What is normalization and why do we need it?
- Asked upto BCNF
HR:
- Why do you want to join oracle?
- What do you know about Oracle? When did you first come to know about Oracle?
- What are your expectations as an Application Developer?
Round 5 [HR Round]: [10 min duration]
They asked about hobbies, favorite football team, about work culture at zepto.