Oracle Interview Experience for Applications Engineer (On-Campus) 2022

Oracle visited our campus to hire for the role of Applications Engineer. The following were the eligibility criteria:

• M.Tech students should have a 4-year B.Tech/B.E degree before joining M.Tech
• The CGPA should be above 7/10 (or a percentage equivalent above 70%)
• There should not be active backlogs in any semester

Round 1 (Online Test):

The test pattern for Round 1 was changed this year. This was an online test hosted on the HackerRank platform on 11th August 2022. It was a proctored exam of duration 105 minutes. There were a total of 9 questions: 2 coding questions, 1 SQL query, and 6 MCQs based on Data Structures and Algorithms.

• Complementary Pairs: https://www.geeksforgeeks.org/count-of-pairs-of-strings-whose-concatenation-forms-a-palindromic-string/
• Relevant Food Outlets: You can refer to the HackerRank REST API section. 

The difficulty of the SQL query and MCQs was easy. MCQs were based on topics like Graph Traversal, Minimum Spanning Tree, Heap, Prefix/Postfix expressions, and Sorting algorithms. 

I was able to solve all the questions except the second coding (REST API) question. The results of this test were declared on 13th August 2022. 78 students were shortlisted for the further interview process to be held on 16th August 2022. The Pre-Placement Talk was held on 16th August from 9 AM to 10 AM.

Round 2 (Technical Interview 1):

This was an online interview. On joining the Zoom meeting, we were asked to join the breakout rooms. Then we were assigned the interviewers. 

• Introduce yourself.
• Write code to print the following pattern dynamically (for n=-1,0,1,10,100)

                          1
                    2         2
             3                       3
        4                                    4
  5                                               5
        4                                   4
             3                      3
                   2          2
                         1

• Explain Java Collections (in detail).
• Puzzle (https://www.geeksforgeeks.org/puzzle-18-torch-and-bridge/)
• Explanation of a Project mentioned in the Resume

42 students were selected for the next round.

Round 3 (Technical Interview 2):

• Introduce yourself.
• Why are you doing MTech?
• Why don't you want to go for PhD despite such good academics?
• Write code to check if a string is a scrambled form of another string. (https://www.geeksforgeeks.org/check-if-a-string-is-a-scrambled-form-of-another-string/)
• Explanation of a Project mentioned in the Resume
• Explain MongoDB database storage. What are the benefits of a NoSQL database over a RDBMS? 
• What are the RDBMSs you have used till now? Explain how storage differs in each of these databases.
• Explain the MVC design pattern.
• Convert the following ER model into a Relational model. List the keys and other attributes for the relations.

                      Doctor-----------------treats---------------Patients
          What are the rules for converting ER model to a Relational model?

• Find outputs for the code snippets:

          a. Based on static methods

          b. Based on parent and child constructor

          c. Based on runtime polymorphism

• Questions from hobbies

19 students were selected for the next round.

Round 4 (Technical+HR):

This round was an offline round. 

• Introduce yourself.
• Open www.sudoku.com and start solving the Sudoku without guessing and backtracking. (If you need to delete a number, it means that you backtracked).
• Explain how you played the game.
• Write and explain the pseudocode for the algorithm you used to play the Sudoku. (NO backtracking)

I was told that I was done for the day and to wait for the results. The entire interview process was held in a day and lasted for 4.5 hours, i.e., from 11:30 AM to 4 PM, without any breaks.

Results were announced at 11 PM on the same day. 14 students were selected for the Applications Engineer role.

Interview Tips:

• Your interviewer will guide you through your conversation. Be sure to follow their cues whilst trying to develop rapport. 
• Try to collect your thoughts before you speak.
• Take your time to answer questions and communicate concisely.
• Your approach matters. Even if your code doesn’t work, don’t worry just try to communicate your approach to the interviewer as they are more interested in how your brain interprets a problem.
• For video conferences and in-person interviews, dress professionally.
• Speak clearly and at an appropriate volume and pace.

I hope this article answers all your doubts. All the Best

Anonymous

Improve

Article Tags :

• Interview Experiences
• Experiences