Oracle Apps Interview Experience (On Campus) for Member Technical Staff

Apti + Technical Test: There were around 4 sections, all the sections were further divided into few subsections. 

  1. Apti: Quantitative, logical reasoning, Flowchart questions. 
  2. Coding skills: C++ output questions, 
  3. Computer Science knowledge: Data Structures insertion, deletion related questions, many questions from AVL Trees, BSTs, stack and queue operations related questions, etc, covered a lot of topics from DBMS (B+ trees, normalization forms, BCNF and all), OS, OOPs, 
  4. Communication 

The questions in the test were from a very wide range of topics. This test was on oracle’s own platform.  Around, 70 students got shortlisted for the interviews. There were 3 Technical rounds and 1 HR round for all, but they took 4th Technical interview of few candidates along with me. 

1st Technical Interview: 

  1. Write code for Nibble swap (Bit Manipulation). 
  2. Reversal of Linked List. 
  3. Program to implement runtime polymorphism (virtual function). 

I was able to write and explain each and every code properly. Please note that they want a very well written proper code. (It took around 25 mins) 

2nd Technical Interview: This round was to check knowledge for core subjects and Project-related questions were asked. Few questions which I remember are: 



  1. All almost every topic related to OOPs
    • The basic definition of OOPs.
    • Define and give some real-life examples of Encapsulation, Inheritance, Polymorphism, data Abstraction, types of polymorphism. (He wanted to check basics and I explained him all)
    • Then, he asked to write code for different types of inheritance.
    • What is a friend function and write code to implement it?
  2. Now, DBMS.
    • What is normalization and why we need to perform that?
    • The basic difference in all types of normalization forms (2NF, 3NF, BCNF).
    • Types of Joins.
  3. Then he asked me how many OS you have worked on. I told him Linux (Ubuntu) and Windows. So he asked me what is the difference between both of them and which of them is better for development and why? My answer was not satisfactory for him but this didn’t affect much. You have to be mentally prepared for this kind of question too.
  4. Some basic Project related queries like how you implemented a few functions.
  5. At last, he gave me a very common puzzle: Measuring 6L water from 4L and 9L buckets

This interview was an explanation kind of and I answered quickly. (Around 30 – 45 mins) 

PS: Always take some time to solve the puzzle even if you know it. 

3rd Technical Interview: This round was to check DS. They asked some basic questions from Tree, Linked List, Arrays, etc. 

  1. Binary Tree Path Sum. 
  2. Boundary Order Traversal 
  3. Lowest Common Ancestor (LCA). 
  4. Detect and remove Loop in a linked list. 
  5. Stock buy and sell. (started from naive approach and optimized it) 
  6. Implement a queue using stack and Implement stack using queue and optimize the push and pop of both. 

These questions were very basic, and they did analyze the code by going through some test cases (dry run).  Also, a very detailed discussion on Time and Space complexities. Probably the longest interview. (45 mins) 

4th Technical Interview: Started asking about the Internship Project. Based on that he asked me to design an airline scheduling system in which Arrival and Departure Times are given and with some conditions that there can’t be more than n flights at a given time on the run-way. I told him correct logic but he wanted me to write proper code using classes and objects. I tried and somehow wrote the code but he wasn’t that much satisfied. The interviewer was Very supportive so he helped me and suggested a few changes. 

Then he asked me some puzzles 

  1. 25 horses puzzle. 
  2. Hour-glass puzzle. 
  3. Then, he asked me some queries.
    • Nth Highest Salary 
    • Some join related query 

HR Round: 

  1. Tell me about yourself. 
  2. How was your interview experience so far? 
  3. Asked for my internship at RIL. 
  4. Why do you want to join oracle? 

9 students out of 70 made it till the HR round out of which 8 got selected including me, so communication also played a small role overall. 

Preparation Tips: 

  1. Thoroughly go through interview experiences as much as you can. 
  2. Practice some basic questions of Linked List and Binary Trees (most imp) and other DS like an array, queue, stack, strings. 
  3. Good knowledge of core subjects like OOPs and DBMS is a must. 
  4. Learn to write SQL Queries. 
  5. Solve and practice puzzles from GFG. 
  6. E-R diagram and Schemas especially if your project has Database related operations.
     


Write your Interview Experience or mail it to contribute@geeksforgeeks.org

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


4


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.