Oracle Interview Experience for OFSS and GBU (On-Campus)

Recently Oracle visited our campus for hiring final-year students for a full-time role. The Position is for Software Applications Developer.

Round 1: Online Test: It was an online MCQ test.

• The test comprised of questions from DSA, DBMS, OS, logical reasoning, Flow chart analysis, etc.
• There was no negative marking but the time limits were very strict and also there was no going back and forth in between questions. So keep an eye on the timer and solve as many as you can but try to attempt all the questions.

After this round, around 50 students were shortlisted for the interviews for both roles.

Round 2: Technical Round 1

• The interviewer was very friendly. He asked me whether I was feeling good.
• He introduced himself first then he asked me to introduce myself.
• First, he asked basic coding questions which were on strings, it was quite easy
• later he asked a question about files, on efficient retrieval of data from files I don’t remember the exact question, he said there is only one operation we can perform that is inserted at the end, you have to say if there are changes in the file or not in an efficient manner
• later he asked oops questions on java
• DBMS questions which you can easily find from javatpoint, most of the questions were asked from javatpoint itself.

Round 3: Technical Round 2: In this interview, I faced 6 coding questions and one idea to develop a backend so that we can retrieve data in an efficient manner

• Coding questions are:
  • https://www.geeksforgeeks.org/implement-stack-using-queue/.He asked to solve using space complexity O(1) and O(n).
  • https://www.geeksforgeeks.org/level-order-tree-traversal/
  • https://www.geeksforgeeks.org/breadth-first-traversal-bfs-on-a-2d-array/
  • https://www.geeksforgeeks.org/dijkstras-shortest-path-algorithm-greedy-algo-7/
  • https://www.geeksforgeeks.org/ceiling-in-a-sorted-array/ and also floor
• Two DBMS questions

Round 4: HR

• The interviewer was very friendly and asked about my future plans
• He asked one a logical question which was easy and another one was he said some idea and formula and asked to detect an error in the formula, this was very easy
• He asked about my family
• My personal achievements
• About my projects which he liked a lot
• The moment where I struggled a lot?

Then he asked me if I had any questions. I asked one question:

Verdict: Selected for OFSS (fulltime)

Tips:

• Be prepared before your interview.
• Stay positive and confident.
• Try to interact with the interviewer, and try to make the conversation flow.