Oracle Interview Experience for Associate Software Engineer

This interview experience is On-Campus for the CGBU unit.

Round 1 – Online Assessment: The first round was the online Assessment in which there were 9 questions.

• 1st question was on REST API.
• 2nd was a basic DSA question. Given a vector of string, find the number of pairs of strings that are made out of the same characters. Ex: “foo” and “of”
• The 3rd one was to write an SQL query. Given a table of names and amounts, we need to print the name of the employees with the Interest (Simple Interest) of each in 1 year of time at 5% p.a.
• The next 6 questions were MCQs regarding B-Tree and time complexity.

Round 2 – Technical Interview: At the start of the first interview round the interviewer asked for my introduction and the round began with some OOPS concepts.

• He asked me to write code on a text pad about how to make a copy constructor,
• What are constructors,
• Runtime Polymorphism,
• How do you overload a function,
• and initialized and uninitialized variables in those overloaded functions?
• Next, he asked me questions about Operating System.
• What are a process and a thread? How are they different from each other?
• When would you use the process and when to use the thread?
• What is the concept of virtual memory?
• Finally, we moved on to some basic Data Structures in which he asked me to do a code in 2 to 3 minutes. The code was to make a diamond pattern. (Question Link)

Then he asked me to find the middle element of a linked list. (Question Link)

Round 3 – Technical Interview: In my second interview, I was asked about the internship experience I had written on my resume and the work I did there.

• Starting off with Tree, the interviewer asked me if I was comfortable with a tree to which I said yes and the round began.
• She asked me what are trees, and BST, how is BST unbalanced, can we make it balanced,
• What is an AVL tree and how do rotations work in AVL trees?
• Then she asked me to briefly explain preorder, inorder, and postorder with the help of code.
• Following this we moved on to more OOPS, in-depth this time, she asked me to write a code that she dictated and find the errors in it. The code was of function overriding without the virtual keyword.
• She asked me about the new keyword and how objects can be declared using other objects with the new keyword.
• Then there was more code that she asked me to write and correct.
• Basically, she wanted to know how confident I was with my OOPS fundamentals.
• Then she asked me what is STL, what is a map, how are maps different from unordered maps, what are Red-Black Trees, and how they work.

Then she asked me to code the given question:

• Given are two arrays indicating the size of the arrays and the direction in which they are moving. A bigger fish can eat a smaller fish if they are moving in the opposite direction. Two fishes moving in the same direction cannot eat each other because all the fishes are moving at a constant speed. Print the output of the fishes which survives.
• She asked me which data structure I would use to store and process the data and why.
• She was happy with my responses and I was sent to the final round.

Round 4 – Managerial Round: This was my final round which lasted for about 5 minutes.

• The interviewer asked me about any project that I did in my college and we had a brief discussion about my project.
• He asked what was the scope of my project, which database did I use and why did I choose that DB, what is CDN and what do you know about Cloud.
• He was satisfied with my answers and the round ended soon after.
• The Interviewers in every round were very friendly and really helpful throughout.
• I received the confirmation mail by the evening of that day itself.

Verdict – Selected