Oracle is one of the largest software based companies in market today and its every engineer's dream to join this esteemed company. The company leads the market in database management systems and its autonomous cloud based technologies.
Oracle recently arrived at my college for recruiting interns for summer of 2021. There were two profiles first one was for Member of Technical Staff (Server Technology Group) and other was Applications Engineer. The online exam for both of them was same. I received the internship offer from Oracle in the Server Technology profile and finally accepted it. So, here is my experience:
The online round consisted of MCQ questions. There were no coding questions.
The test comprised of Aptitude and Technical Questions. There were around 4 sections, all the sections were further divided into few subsections. Each subsection had its own timing. The questions were not tough but the time given was very less. You have to be extremely quick here. If you are in regular practice of aptitude, Data structures and Algorithms and Basics of Computer Science Questions MCQs the online round would not be difficult.Test was held on platform of the company itself.
Here is detailed description:
1. Aptitude: Quantitative and logical reasoning.
2. Software Engineering Basics: Data Structures insertion, deletion related questions, many questions from AVL Trees, BSTs, stack and queue operations related questions, Flowchart problems.
3. Computer Science knowledge: Covered a lot of topics from DBMS (B+ trees, normalization forms, BCNF and all), OS, OOPs, etc.
4. Communication: There were English Comprehension questions, verbal aptitude type questions which were quite easy and anyone with decent English can attempt these easily.
Preparation Sources :
1. GFG - https://www.geeksforgeeks.org/quiz-corner-gq/
2. Indiabix - https://www.indiabix.com/
3. PrepInsta - https://prepinsta.com/oracle/
Now Coming to the interview rounds:
Interview Rounds
All the interview rounds were held on Zoom platform. The process was smooth.
Round 1 (Duration – 40 mins)
The round started with discussions on my projects and how I started developing interest in software domain despite being from electrical branch. There was some cross-questioning on projects (I had already done projects on deep learning and web development), so some general questions were asked.
Interviewer asked me whether I was comfortable with OOPs, I told him that he could ask questions from it. So, he asked me basics such as encapsulation, abstraction, polymorphism, etc. Then he asked me to write the code for compile time and run time polymorphism, which I did with ease.
Here is link for the same: https://www.geeksforgeeks.org/virtual-functions-and-runtime-polymorphism-in-c-set-1-introduction/
Next, he asked me about my favorite data structures, to which I replied Arrays, Binary Trees and Linked Lists. He then asked me following questions based on it:
1. Difference between BT and BST.
2. Code for insertion and deletion in BST. (It’s very important to take care all the cases).
3. This famous backtracking question of solving sudoku: He asked me to design a sudoku with empty spaces to be filled using an appropriate data structure and solve it. I first told him a brute force approach and later a backtracking one. He then asked me to write code for the same. Link to question: https://www.geeksforgeeks.org/sudoku-backtracking-7/
The interviewer was quite friendly and he was mostly concerned with the approach and concept of solving a question rather than the code itself. He was constantly asking me for the time complexity of my solution. Also, the IDE provided by them was their own and it was not kind of user friendly, so be prepared for it.
Round 2(Duration – 45 mins)
Again, the interview started with discussion on my projects.
The interviewer asked some questions from the resume, some basics of C++ like:
What are templates in C++, difference between libraries and header files, questions on sorting algorithms, access specifiers, inheritance, constructors, destructors and major OOPs concepts.
Then he asked some questions from my Django based project and asked me how I will productionize the project. I had already hosted my website on Heroku, so I knew all that stuff. Then questions on cloud computing were there (the interviewer was working on cloud computing) so he asked lot of questions on the topic.
Then he asked me what subjects are my favorites in Electrical Engineering. I just replied network analysis, control systems, etc. To my surprise he asked me Kirchhoff’s both current and voltage law (quite unexpected). So, it could be possible that interviewer may ask something that is unexpected, always be prepared for that.
After that there were general HR type questions and at the end interviewer asked me if I have any questions, I asked him about technologies that Oracle is using in the field of cloud computing and how they deploy everything on such a large scale. Then he like explained me everything for next 4-5 mins and the interview ended on a good note.
All the interview rounds were held on Zoom platform. The process was smooth.
Round 1 (Duration – 40 mins)
The round started with discussions on my projects and how I started developing interest in software domain despite being from electrical branch. There was some cross-questioning on projects (I had already done projects on deep learning and web development), so some general questions were asked.
Interviewer asked me whether I was comfortable with OOPs, I told him that he could ask questions from it. So, he asked me basics such as encapsulation, abstraction, polymorphism, etc. Then he asked me to write the code for compile time and run time polymorphism, which I did with ease.
Here is link for the same: https://www.geeksforgeeks.org/virtual-functions-and-runtime-polymorphism-in-c-set-1-introduction/
Next, he asked me about my favorite data structures, to which I replied Arrays, Binary Trees and Linked Lists. He then asked me following questions based on it:
1. Difference between BT and BST.
2. Code for insertion and deletion in BST. (It’s very important to take care all the cases).
3. This famous backtracking question of solving sudoku: He asked me to design a sudoku with empty spaces to be filled using an appropriate data structure and solve it. I first told him a brute force approach and later a backtracking one. He then asked me to write code for the same. Link to question: https://www.geeksforgeeks.org/sudoku-backtracking-7/
The interviewer was quite friendly and he was mostly concerned with the approach and concept of solving a question rather than the code itself. He was constantly asking me for the time complexity of my solution. Also, the IDE provided by them was their own and it was not kind of user friendly, so be prepared for it.
Round 2(Duration – 45 mins)
Again, the interview started with discussion on my projects.
The interviewer asked some questions from the resume, some basics of C++ like:
What are templates in C++, difference between libraries and header files, questions on sorting algorithms, access specifiers, inheritance, constructors, destructors and major OOPs concepts.
Then he asked some questions from my Django based project and asked me how I will productionize the project. I had already hosted my website on Heroku, so I knew all that stuff. Then questions on cloud computing were there (the interviewer was working on cloud computing) so he asked lot of questions on the topic.
Then he asked me what subjects are my favorites in Electrical Engineering. I just replied network analysis, control systems, etc. To my surprise he asked me Kirchhoff’s both current and voltage law (quite unexpected). So, it could be possible that interviewer may ask something that is unexpected, always be prepared for that.
After that there were general HR type questions and at the end interviewer asked me if I have any questions, I asked him about technologies that Oracle is using in the field of cloud computing and how they deploy everything on such a large scale. Then he like explained me everything for next 4-5 mins and the interview ended on a good note.
Tips:
1. Go through all previous experiences from gfg - https://www.geeksforgeeks.org/tag/oracle/
2. Practice questions from leetcode and Interviewbit - Arrays , Linked Lists , Trees , Backtracking (IMP Topics)
3. Revise OOPs concepts.
Hope this Helps !!
For questions please put them in comments section :)
Comments
Post a Comment