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:

1. Given a string, print all permutations of that string that are greater than it.
2. Knapsack Dp question
3. Have you used Oops in an internship? (I explained singleton class and wrote code)
4. Basic oops questions?

Overall difficulty: Easy

Round 2:

1. Given the birth and death years of N people. Find the year with max population.
2. 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
3. Asked about internship experience and tech stacks used.
4. 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.
5. Design a Hotel Booking System (high-level design and schema design)

Overall difficulty: Medium – Hard

Round 3:

1. Asked about internship experience
2. 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:

1. Concurrency vs parallelism?
2. What is a deadlock? Necessary conditions for deadlock to occur?
3. Deadlock avoidance, prevention, removal etc. What is RAG?

DBMS:

1. What is normalization and why do we need it?
2. Asked upto BCNF

HR:

1. Why do you want to join oracle?
2. What do you know about Oracle? When did you first come to know about Oracle?
3. 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.