Oracle On-Campus Placement for the role of Application Developer.
Round 1: Q1. Given a string, print all permutations of that string which are greater than it. Q2. Knapsack DP question Q3. Have you used OOP in your internship? (I explained the singleton class and wrote code) Q4. Basic OOP questions? Overall difficulty: Easy
Round 2: Q1. Given birth and death year of N people. Find the year with max population? Q2. 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, m-1 having max score. You can travel in all 4 directions Q3. Asked about internship experience and tech stacks used? Q4. Asked in-depth questions related to a personal project (Chat application with video and voice calling feature). Asked why you have used this tech stack. Gave me 2-3 new features to implement. Q5. Design a Hotel Booking System (high level design and schema design) Overall difficulty: Medium - Hard
Round 3: Q1. Asked about internship experience Q2. 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 questions in OS and DBMS OS: Q1. Concurrency vs parallelism? Q2. What is a deadlock? Necessary conditions for deadlock to occur? Q3. Deadlock avoidance, prevention, removal etc. What is RAG? DBMS: Q1. What is normalization and why do we need it? Q2. Asked upto BCNF
HR: Q1. Why do you want to join Oracle? Q2. What do you know about Oracle? When did you first come to know about Oracle? Q3. What are your expectations as an Application Developer?
Round 5: 10 min HR Round: asked about hobbies, favorite football team, about work culture at Zepto.