Company: Oracle
Location: Bangalore/Hyderabad
Profile: Application Engineer

Written Round:
The written round was conducted on oracle’s platform and the duration was 122 minutes precisely.
It consisted of mcq’s on 4 major areas – Software aptitude, English, coding skills, technical skills (like OS, DBMS, OOAD,CN). The 4 sections were further subdivided into 4-5 smaller sections containing 7- 8 questions each and each subsection had a time limit of around 8-10 minutes. There was only fwd scrolling ( so once you skipped a question, you would have to traverse till the end and then loop back). Also once marked, you cannot change your answer for the question. There was nothing mentioned about negative marking.
Around 65 students were shortlisted for each of the 2 profiles (server tech being the other profile)
out of 355 students.

F2F Interview 1 (Technical)(45 min):
Due to large number of candidates shortlisted for interviews, each interviewer was handling 2-3
candidates simultaneously . He directly fired different coding questions on us without wasting even a second. I was given to implement next_permutation() function of c++ and the other student was asked about the excel sheet problem http://www.geeksforgeeks.org/find-excel-column-name-givennumber/.
After this round I was told to wait outside. Another interviewer was present there and he quickly
asked me 2 more coding questions http://www.geeksforgeeks.org/a-product-array-puzzle/ and the
other question was - given a paragraph find which alphabet doesn’t occur in it. The key to this roundwas to give simple, quick and optimal solution wrt time and space. A normal solution led to direct exit from this round without any deliberations.

F2F Interview 2 (Technical) (2 hr):
The same interviewer took me in for the next round. In this round he was even more strict and
direct. He first asked me about the manhole puzzle, I started giving him the solutions that i knew
but he refused to agree to any of them, finally after 7-8 possible solutions he changed the question saying that all solutions were wrong. Then he told me to design a database that could calculate and predict using queries the finishing date of a project assigned to me. (given to me was list of jobs involved in the project ,their dependencies and time taken to complete each job ). Again he started refuting all my solutions and indirectly stressed that I better give the correct solution or exit !!! Then finally after 1.5 hrs he agreed to my solution. He revealed that he was satisfied with all my solutions from the start. (so basically it was kind of a stress interview and he wanted to see how many solutions can I come up with).

F2F Interview 3 (Managerial) (75 min):
After the second interview I was called in for the managerial round that was taken by the senior
most Interviewer of the panel. He was very friendly and helpful and started a general discussion
about me, my hometown, family etc. Then he moved on to my resume and went through it line by
line , cross-questioning me at every stage about my school, achievements, projects etc in detail.
After this he asked me some technical questions about normalization with examples. Then he asked me Why Oracle ? and why this profile? There were some questions from the PPT as well !!! Then he gave me a design question in which I had to make screen shots of an app for Library management , covering all aspects and details. I also had to make the back end tables in a normalized manner along with the functional dependencies. I continued for about 45-50 minutes and he was satisfied by my solution. In the end he asked if I had any questions and I asked 2-3 questions. He then recommended me for HR round.

F2F Interview 4 (HR) (20-25 min):
The HR lady was neither friendly nor strict. She started by asking about my background, my family, hobbies etc. Then she asked Why oracle? She also aked about my location preference and the reason behind it. This was followed by a character test where she enquired about my strength and weakness.I was again asked some questions from the PPT !!! In the end she asked if I had any questions for her and I as ked 3-4 questions.