Oracle Associate Consultant Interview Questions, Process, and Tips for Freshers

Round: Test
Experience: It is a section wise test , you will not be able to go back to earlier sections after you submit them. No negative marking.
In the first section questions were asked based on data reasoning, logical interpretation, ages, work, speed and time. 40 questions 40 mins
In the second section , questions were asked based on C/C++, Object oriented programming. Some code snippets were given and we were asked to give the outputs. 40 questions 40 mins
In the third section, questions were asked on DBMS, data structures and their applications. Flowchart based questions were also asked. 20 questions 40 mins
In the verbal section, questions were based on identifying grammatically correct sentences, identifying the correct word for a phrase, correct usage of articles. 20 questions 20 mins
Tips: For general aptitude refer to any standard book and learn the formulae , they will help you to solve questions quickly. For DBMS and C/C++ refer to any standard textbook.
Duration: 140 minutes
Total Questions: 120

Round: Technical Interview
Experience: The interview lasted for 40-45 minutes. Initially they tested my technical knowledge, they asked me about my internship. They asked me to explain about my projects. He asked me to explain how banks work and process that happen in banks. Then the interview turned to more of a HR interview. They asked me about my hobbies, interests.
Tips: Be confident and presently yourself properly. The interviewers will try to instill some doubt on the answers even if they are correct to check if the person holds his stance, if you feel you have answered correctly , justify it. Also it is better to accept topics which you do not know about.

Round: HR Interview
Experience: The HR interview was more relaxed The discussed about my blogging hobby and asked to tell my latest post. He asked me my opinion about consulting and what i know about it.

General Tips: Be on time for the aptitude test as well as the interviews, it shows your punctuality. Present yourself neatly (dressed appropriately) , preferably clean shaven.
Skills: C/C++ , DataStructures, Knowledge about banks, Logical reasoning
College Name: BMS College Of Engineering, Bangalore
Motivation: I have always wanted to work for Oracle, this has been my biggest motivation. Also my seniors told me its a good company to work for, hence i was more motivated.
Funny Moments: In the technical interview, the interviewer asked me to talk about any recent happenings. He said it could be anything. Political, Sports, religion, movies.. My mind was blank i was very tired with the process. When he said movies , i grabbed the opportunity and told him about a recent kannada movie called 'UPPI2' which had released on that on that day. He told me to tell something else , so I started talking about another telugu movie called 'Baahubali'. Then he started laughing and said "oK, enough of movies, tell me something else."