# Oracle Interview Experience | Set 57 (On-Campus for FTE)

• Difficulty Level : Medium
• Last Updated : 12 Aug, 2021

Here is how my interview for ORACLE (Profile: App Dev) went about:

Round 1:
This included MCQs that covered a lot of topics, such as Data Structures, OS, Database, English Grammar, General Vocabulary, Basic Math, and a few basic logic.
Roughly 150 students out of (~350) were shortlisted for the next round.

Round 2:
This was a coding round, had 2 questions. Both were math-based questions.
This was not an elimination round, but was to segregate the students into 2 groups, (Server Tech. and App Dev.).

Interviews:

Round 1:

Question 1: Write the code to find the 2nd largest number in the array.
You are expected to write the code and test for all edge cases.

Question 2: Print all the prime factors of a given number except the number itself.

Question 3: This was to just check your quick math/logical skills.
If ABCD*99=ABB551, find the value of A.
I had a discussion with the interviewer regarding this and I gave him the answer in a way that he did not expect and he seemed quite happy about the new method ðŸ˜›

Round 2:

Question 1: Why Oracle? What do you expect Oracle to be like, for you?

Question 2: The interviewer gave me a set of relations and asked me to write a couple of queries to retrieve certain data.
I would say, as it is Oracle, you should be thorough with DBMS and MySQL queries.

Question 3: Write code to group all 1s in K-map.
I wrote a code using DFS.

Question 4: Given a roman number as a string input, check if it is valid, if yes, then print its decimal equivalent.

Question 5: What are the data structures?

Question 6: Explain any sorting algorithm of your choice.
I started with quicksort, however, he later asked me to explain bubble sort ðŸ˜›
He also asked me if I knew why was it named “bubble” sort.

Round 3:

Had to answer around 5 logical puzzles.

Round 4:
Question 1: Given a sudoku puzzle, write code to check if it is valid (solved right) by traversing the entire matrix just once.

Round 5:
HR interview, here I was asked about my background, what was it that I considered unique about myself, my future goals, etc.

On the whole, I would say, with a good grip on database, OS, Java concepts, and of course, data structures and algorithms you will be able to make it through easily.

All the best! ðŸ™‚

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

My Personal Notes arrow_drop_up