Oracle || Application Intern || (OFF CAMPUS) || Selected

So it all started with me getting a mail from OracleRecruiter for the OA (Online Assessment) in the first week of May ’21.

The mail had a test Link with an expiration of 1 week so I needed to attempt the test within a week.

Round-1 (Online Assessment)
Structure
In OA round, I was given two coding problems to solve within 90 minutes and I had to explain the Time and Space complexities of each problem in separate questions.

So, in total there were four questions. 2(Coding) + 2(Explanation of those Coding Problems).

In the First week of June , I got a mail from recruiter stating that I have cleared my Online Assessment and there was a Preparation Session scheduled later that week.

Round-2 (Technical Round)
Please note that I have not revealed exact DSA question which was asked in Technical round due to NDA (Non Disclosure Agreement) and have tried to explain a similar question to one asked in interview.

1)https://leetcode.com/problems/median-of-two-sorted-arrays/description/
2)https://leetcode.com/problems/remove-duplicates-from-sorted-list/

similar question asked in a interview. and this was conducted in hackerearth code pair

Round-3 (Hiring Manager Round)
Structure
This round was taken by a Sr. SDE from Oracle. The round started with general introduction of interviewer followed by mine. The interviewer told me about the projects he previously worked on and also asked me about the tech stack . This went on for good 10 minutes.

Then for the next 15–20 minutes, I was asked quite a few Leadership Questions and I had to explain different scenarios depicting those Leadership Principles.

For the rest of the interview (30–35 minutes), I was asked Computer Science Fundamentals spanning across topics like Operating System, OOPS, DBMS, DSA etc.

Computer Science Fundamentals

I was asked around 10–15 questions. Some of them are given below:

Object Oriented Programming and its advantages
Difference between Compositon and Inheritance
Different types of Scheduling Algorithms
Critical Section Problem
Difference between Semaphore and Mutex
Stored Procedure
SQL vs NoSQL

Round 4:It was an HR Interview.
Questions were:

Tell me something about yourself.
What is your Goal?
What are your strengths and weaknesses?
If not Oracle then which company will you choose and Why?
How Oracle is fit for you?
Oracle’s Favorite Topics: Easy and medium-level Coding questions (with Time and Space Complexity), OOPs concepts, and SQL Queries.

------------------------------That’s it… Hope you liked this-----------------------------------------