I applied through a recruiter. The process took 2 months. I interviewed at Oracle (Bengaluru) in Apr 2015
Interview
Two technical rounds - both were average. Interview were friendly and asked relevant questions.Questions were on SQL and PLSQL. The offer came after two months. During the period the HR was in constant touch.
Interview questions [1]
Question 1
How to find second largest salary
How to remove duplicates
2 rounds of technical - They will ask all the technical questions based on your resume. Quite difficult
1 Manager Round - They will ask technical questions and managerial questions
Interview mostly they will ask the basics but from each and every topic for Oracle DBA like configuration, architecture, RMAN, EXP/IMP, Performance Tuning, RAC, Golden Gate, Exadata and Cloud platform question etc.
There was 2 technical interview and one managerial round. L1 round was with some Java coding using stream and theoretical questions and L2 round was more about the scenario based questions