I applied in-person. The process took 2 weeks. I interviewed at Oracle (Los Angeles, CA) in June 2014
Interview
I applied online through Oracle page, and they contacted me right immediately like on that day which was scary for me. I got an e-mail with to complete some online test with 13 questions and they were on:
25 questions:
15 Analytical Multiple Choice Questions – focusing on sets, trend analysis, calculus, stats, etc.
5 open ended basic SQL question.
3 open ended database normalization question.
1 Multiple Choice English language comprehension question.
1 open ended language question (this part should be 200 – 300 words).
The entire online assessment test was conducted through hackerrank.com and it was for 90 min.
Personally I did not go and complete the Quiz within couple of day. I did take my time to prepare and I was right. It is a difficult test. I did use apps like ‘the impossible interview’ and ‘the aptitude interview’ from iTunes app store to prepare. They were a help.
Interview questions [1]
Question 1
An analyst at Oracle is conducting a satisfaction survey, sampling from a list of 10,000 new users. The list includes 2,500 French users, 2,500 German users, 2,500 Italian users, and 2,500 Portuguese users, The analyst selects a sample of 400 users, by randomly sampling 100 users of each country. Is this an example of simple random sample?
It was mixed from AWR report, RAC and performance based.
Wait Events.
Execution plan.
Different questions included.
Rac installation and patching included.
Questions from memory structure.
Voting disk and ocr file.
Interview questions [1]
Question 1
It was mixed from AWR report, RAC and performance based.
Wait Events.
Execution plan.
I applied through a recruiter. I interviewed at Oracle (Dubai)
Interview
It was medium-hard process of interviews the first one was an assignment the second was a technical interview and at last it was an HR final interview, so it wasn’t that easy or that hard
Interview questions [1]
Question 1
What is the most challenging problem you went through and how did you solve it
I applied online. The process took 4 weeks. I interviewed at Oracle (Pleasanton, CA) in Aug 2025
Interview
The process started with a 30-minute recruiter screen about background and timeline. Next was a 60-minute technical video interview covering SQL tuning, RMAN backup/restore, Data Guard, and performance troubleshooting. A second technical round focused on real incident scenarios and on-call approach. Final round with the hiring manager discussed stakeholder communication, prioritization, and cross-team collaboration. Communication was clear, expectations were transparent, and the interviewers were professional throughout.
Interview questions [1]
Question 1
Walk me through how you would diagnose and remediate a sudden performance regression on a critical Oracle database.