Oracle Interview Experience | Applications Developer ( Full Time)

Hello, my name is Parth Thakkar, and I am currently pursuing a B.Tech. in Electronics and Communication at Nirma University. Recently, Oracle visited our campus for a recruitment drive for the Application Developer position. I participated in this drive, and I would like to share my experience with all of you.

The Online Assessment

The process began with an online assessment test on July 29, 2024. The test consisted of one coding question, twenty technical questions, and fifteen general aptitude and communication questions.

The coding question was as follows:

You are given `n` queries involving `student1` and `student2` of size `n`. If `queries[i] == 'friend'`, you connect `student1[i]` and `student2[i]`. Otherwise, if `queries[i] == 'total'`, you count the total number of friends in the group of `student1[i]` and `student2[i]` and store the total in an answer vector, which is returned at the end.

I managed to solve this coding question successfully.

The technical questions were multiple-choice, covering core computer science subjects such as DBMS, OS, and CN, along with output-based questions.

Out of approximately 215 students, 101 were shortlisted for the next round, and I was one of them.

The Face-to-Face Interviews

The face-to-face interviews were held on August 1, 2024, and consisted of four rounds.

Round 1:

The first round began with a brief introduction. I mentioned that our team had recently won a hackathon at our university, which prompted the interviewers to ask about our project and my contribution to it. Following that, they asked me two coding questions:

1. Find the first non-repeating character of a given string.

- GeeksforGeeks article

- Problem

2. Sort the arrays containing 0's and 1's.

- GeeksforGeeks article

- Problem

I was able to solve both questions, which led to an invitation for the second round.

Round 2:

The second round also began with an introduction. The interviewers then asked me two DSA questions:

1. Maximum absolute difference between the sum of two contiguous sub-arrays.

- GeeksforGeeks article

2. Given two quadrilaterals with four coordinates each, determine if they overlap, are subsets, do not overlap, or are touching.

Following the DSA questions, they tested my knowledge of SQL. I was asked to write queries to:

- Find the second-highest salary from a table containing `id` and `salary`.

- Find the fifth-highest salary.

- Given an additional column `dept_id`, find the second-highest salary department-wise.

I was successful in this round and moved on to the third round.

Round 3:

In the third round, after the usual introduction, I was given one question:

- Given a date in string format and an integer `n`, print the date after `n` days.

Unfortunately, even though I was able to solve this question, I still couldn't make it to the final HR round. Despite this, the experience was invaluable and provided me with great insights. The entire process was extensive and spanned the entire day.

You can connect with me on LinkedIn: LinkedIn

Thank you for reading about my experience!