I applied in-person. The process took 2 weeks. I interviewed at Oracle (Los Angeles, CA) in Jun 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?
I applied through a recruiter. I interviewed at Oracle
Interview
HR called for telephonic interview. 4 Technical rounds followed by final Manager's interview.
Interview questions [1]
Question 1
Focus mainly on DB fundamentals like backup/recovery,cloning ,performance tuning. For Apps DBA, installations: advance steps such as , shared appltop, PCP etc