Oracle Interview Experience for Software Developer 2019
Recruitment Procedure :
- Online Test
- The test was around 110 to 120 minutes and had only MCQ questions with single option correct
- Questions were from following domains
- General Aptitude
- Everyday Mathematics
- Algebra
- General questions on Mental Ability Test
- DSA knowledge
- Most questions were from AVL trees
- Some questions on generic algorithms and time complexity
- Design problems with empty sections where the correct pseudocode were to be filled
- Operating Systems
- Surface level questions from the course
- Database
- Questions on queries, joins and ACID properties were asked
- www.oracletutorial.com/oracle-basics ( This website is useful in this case)
- Computer Networks
- Surface level questions from the course
- English proficiency
- Grammar Questions
- Sentence re-sequencing
- Semantically accurate sentence
- General Aptitude
- You can choose which section to solve first and each section had its individual time limit from 6 to 15 minutes
- Technical Interview (I)
- It was more like a résumé discussion round and the interviewer asked me about my latest project ( Blockchain )
- He told me to explain Blockchain in Layman’s term
- How does a blockchain follows ACID properties without having a central database
- How can generics be implemented on Blockchain Ledgers.
- Was asked to write a program on reversing a linked list
- Was given test cases to dry run the code
- All possible cases where the code would fail
- Was asked to write a program on detecting a loop in linked list
- Was asked to give all possible approaches I can think of and what are the trade off between them.
- It was more like a résumé discussion round and the interviewer asked me about my latest project ( Blockchain )
- Technical Interview (II)
- I was told that floyd cycle detection algorithm has been reduced from a general approach
- Was asked to look at the broader picture and how the algorithm was derived ( not the proof )
- Provide proof of the parts mathematically
- I was asked my views on SQL vs NoSQL and when to use what
- Were asked some questions and was given 10-15 second to solve
- make 6 from three 1
- make 6 from three 10
- I was asked the scope of dynamic programming and trade offs involved with real life cases
- I was told that floyd cycle detection algorithm has been reduced from a general approach
- HR Round
- Was asked about routine of a generic day
- He looked at my résumé and asked why my CG is low as compared to my peers and any achievement that compensates for it
- He looked at my résumé again and asked about any project where I had a major setback because of Time/Space complexity issues
- Was asked questions like why should not they hire me
- I was then asked what 3 things should an organization look in a potential candidate and what 3 things a candidate looks for in their dream company
Sources of Preparation
- Interviewbit / Leetcode( Programming practice )
- GFG ( last minute notes and theoretical concepts of DSA )
- java-t-point ( OOP concepts )
- Oracle Tutorial ( SQL basics )
Note:
- When you are stuck at some part of the algorithm ask them for hints ( they are generally helpful )
- Avoid saying I cannot solve it / I don’t know give it a try and ask for help if necessary ( Past Experiences )