Oracle Interview Experience | On-Campus (Application Engineer)

Round 1: It was an MCQ test consisting of general topics like quantitative aptitude, logical reasoning and technical topics like Data Structures (majority questions were based on tree), OS, DBMS and Computer Network. The main concern is time constraint, you will get like only 100 min on whole so you have to be really quick. Questions are of moderate to high level and there is no negative marks (guess work is vital :P). They shortlisted around 50 from 200 applicants.

Round 2: It was a face to face interview. I am from Electronics background and didn’t know much about core CS subjects, but I informed them about my  passion for coding. They were kind enough to keep that in mind and didn’t delved much into core CS subjects. In this round they asked me 2 coding questions and 1 SQL query. Coding questions were.

1. There are 2 strings a&b you have to count the number of instances of second string in first. For eg: string 1 is abcfghabcjurabcheuhr and string 2 is abc. The output should be 3.

2. You are given an nxm matrix .    {{1, 2, 3, 4, 5, 6, 7},

{8, 9, 10, 11, 12, 13, 14},



{15, 16, 17, 18, 19, 20, 21},

{22, 23, 24, 25, 26, 27, 28},

{29, 30, 31, 32, 33, 34, 35},

{36, 37, 38, 39, 40, 41, 42}

{43, 44, 45, 46, 47, 48, 49}};

Print output as 1 9 15 23 31 37 44 ie from (0, 0) increment i value and for j value increment and decrement it in an arithmetic progression.(0, 0) (1, 1) (2, 0) (3, 1) (4, 2) (5, 1) (6, 0) (7, 1) etc.

for first question, I missed an edge case but the interviewer pointed it out and I made the correction, and second question i did by my own. The SQL query was, from a table find the employee who has the second highest salary. Then he asked me about OOP concepts mainly polymorphism. Overall interview was pretty chill.

Round 3: This was again a face to face technical interview. The interviewer gave me two questions . First one was to write all phases of compilation. Since I wasn’t from CS background I didn’t know much about it. Second question was to write a code for insertion and deletion operation in Linked list. Later he asked me about my projects and some questions regarding electronics. There was also some questions regarding data structures and OOP concepts.

Round 4: This was again a face to face technical interview. Since I wasn’t much proficient in CS subjects they again tested my coding skills. The question was there will be 2 arrays consisting of login and logout times You have to find the maximum concurrent logins. Then there was an output prediction question and one correct the error question. He also asked questions regarding cloud computing, machine learning, big data etc

Round 5: This was a HR  round, and all sort of generic questions were asked like why oracle and also regarding my hobbies, my internship etc. They also asked my current offers.

Verdict: Rejected. Even though I was rejected it was a pleasant experience and I learned a lot about my shortcomings 🙂

Write your Interview Experience or mail it to contribute@geeksforgeeks.org

My Personal Notes arrow_drop_up

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

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.