My Oracle Interview Experience - 4 Tips for every interview.
Very Important interview tips are Tip 2, Tip 3 and Tip 4.
If you are not a Medium member then you can use below friendly link to read the complete story.
Friendly Link so that everyone can read my article.
Hi Reader!!!
Let me share my Oracle Interview Experience for Software Developer job role. I had 6 rounds of interviews including an online test. Before writing this article, I went through some recent Oracle Interview Experiences and found that their pattern of taking interviews has been the same for the last few years. Based on my and others’ interview experiences, I am going to share favorite topics of Oracle which they will ask for sure.
Let’s begin.
Online Test (Test Duration was 100 minutes):
- Aptitude
- Verbal
- Coding Skills Question: Output Questions in C, C++, and Java.
- Computer Science Knowledge: Data Structure, DBMS, and Operating System.
All the above sections had subsections and each subsection had a time limit. It was not so easy, so prepare it very well especially aptitude and verbal.
Tip 1: For aptitude, I recommend to prepare from IndiaBix. Practice “General Aptitude” and “Verbal and Reasoning”. It’s simple aptitude but you should know at least what’s given on IndiaBix.
66 students out of 230 were shortlisted for interview rounds.
Interview rounds had no time limit as such. They were flexible with time and gave us more than sufficient time. They are flexible with any language for writing code but knowing Java will give you more favor as they use Java in the company.
Round 1:
First, an interviewer asked me to explain the research paper on “Cloud Computing” which I mentioned in my resume. Then he asked two coding questions. We discussed many approaches and then I did implementations. One question was easy and I was asked to write its code in Java(preferable) and one was a Leetcode medium-level question. Then he asked for some Java concepts and SQL queries. They will not ask simple SQL queries. You should be aware of correlated subquery and nested subquery. They asked me to write an SQL query to find 2nd highest salary of an employee.
Summary: Questions on Resume, Coding, Java, and Sql.
Tip 2: Thinking out loud can help during the interviews. Please say what you are thinking. It helps interviewers to know your thought process and they will guide you if you’re on the wrong track.
Round 2:
1. A list of numbers was given. Arrange numbers in decreasing order of their frequencies and if two numbers have the same frequency then arrange them in increasing order of their value.
Ex: 3, 4, 4, 4, 4, 5, 5, 5, 2, 2, 2.
Ans: 4, 4, 4, 4, 2, 2, 2, 5, 5, 5, 3.
2. Spiral order of tree using only one data structure i.e. you are not allowed to use two stacks.
3. Define tables and make an ER Diagram on the WhatsApp application.
Summary: Coding and Database Management System
Tip 3: Questions like ER Diagram on WhatsApp Application are very open-ended. So, before working on solution, please ask questions to the interviewer to know what exactly they are looking for.
Round 3:
One question on the graph was asked to all the candidates who were qualified for this round. This round was highly elimination round.
The question was, given the cities and roads connecting them. We have to find the shortest path between the source city and the destination city. It was based on Dijkstra’s Algorithm.
Summary: Coding Only.
Tip 4: As per my interview experiences, tree/graph questions are mostly asked by companies. So practice them more.
Round 4:
Two puzzles. One was very easy. The second one was “I have given four 7’s and ‘+’, ’-‘, ’*’, ’/’, ’%’, ’.’ as operators. I can use operators as many times. Write an expression to get an answer 100.
Ans: (7*7)/(.7*.7)
Summary: Puzzles
Note: No need to do any practice for puzzles. Generally, companies don’t ask but Oracle asks sometimes. That’s okay. Try to solve it on the spot.
Round 5:
It was an HR Interview. Questions were:
1. Tell me something about yourself.
2. What is your Goal?
3. What are your strengths and weaknesses?
4. If not Oracle then which company will you choose and Why?
5. How Oracle is fit for you?
Note: None of the questions have any specific answer but be reasonable for your answers.
Oracle’s Favorite Topics: Easy and medium-level Coding questions (with Time and Space Complexity), OOPs concepts, and SQL Queries.
That’s it… Hope you liked this article. Please do at least “one clap, one comment, highlight at least one line which you like the most, follow and share.” It motivates me.
Also, feel free to read my Microsoft Interview Experience given below.
Connect with me on LinkedIn if you are looking for coding tips, interview preparation, and interview tips. Check out my other interview-oriented articles here.
Thank You!!!
