Oracle Associate Consultant interview questions

3-step process 1. Screening phone call with HR rep 2. Behavioural interview with Senior Consultant 3. SuperDay - multiple interviews (group and individual) About SuperDay It was a full day of interviews and group exercises that ran the whole day and was virtual. Behavioural interview, situational interview, case presentation, group exercise, group interview.

Overall interview process was smooth and good. First round of online test consists of aptitude, mathematical reasoning, verbal reasoning, CS concepts (DBMS and OS), two Contextual questions. I got shortlisted for interviews. First interview was mostly coding interview in which I was asked to write few codes and then one theory question on DBMS (explain normalisation and why is it necessary?). After this interview, I was asked to wait in zoom waiting room and told I cleared the interview and will be moved to further interviews. Second interview was technical+managerial. Starting with few tricky yet easy coding questions he jumped to DBMS & SQL concepts ( different forms of normalisation and SQL joins). Then he asked do I have any plans on higher studies. He seems to be satisfied with my answer. Overall this interview was very interactive and kind of discussion rather than what we think of an interview is. Again I was asked to be in waiting room, and told that I cleared the round. HR informed me that third interview is an HR interview. Finally, HR interview started with greeting and asked to speak about anything for a minute (just like a JAM) and then I was informed that results will be shared to TPO by that day night only. Next day morning while I was waiting for the results mail, it arrived and my name was on the list.