Oracle | On Campus FTE - ASE | Experience | 2024

Oracle On-Campus Interview Experience | 2024 Batch

I am a B. Tech student from a Tier 1 National Institute, and my interviews were conducted offline except for the Online Assessment.

Round 1: Online Assessment

The first round was an Online Assessment on the HackerRank platform, lasting 100 minutes. It comprised 10 Aptitude Questions, 10 English Verbal Reasoning Questions, 1 Coding Question which was 'Lexicographically Largest Subsequence', and 1 Rest API Question related to 'Maximum Transfer' similar to those on HackerRank. I found this round to be easy and straightforward.

Interviews

Technical Round 1 (40 mins)

In the first technical round, the interviewer started by asking me to explain GitHub and its various commands. We then discussed different types of Version Control Systems (VCS) and what actions should be taken when merge conflicts occur in GitHub. Following this, I was given an HTML/CSS problem: given three overlapping boxes, when the mouse pointer moves over one box, that particular box should come to the forefront, and on moving out, it should return to its original place. A significant part of the round was a Data Structures and Algorithms (DSA) question, which was LeetCode 42 Hard - Trapping Rain Water. I was also asked to explain various sorting techniques, with a specific focus on Heap sort, where I had to write the code and perform a detailed dry run. Finally, we discussed different ways to store a Tree. I concluded the interview by asking two questions to the interviewer.

Technical Round 2 (70 mins)

The second technical round began with the interviewer reviewing my resume and asking me to explain each of my projects in detail. Questions about Machine Learning/Data Science concepts were asked thoroughly, specifically related to my projects, including dataset-based SQL questions. We covered terms like Precision, Recall, MSE, CNN, KNN, and Clustering, and I provided real-world examples for each. I was also asked about the electives I had taken (Data Mining and Cryptography) and faced questions related to those subjects. After about 45 minutes, the discussion shifted. I was asked about my plans for higher studies and why I hadn't completed any internships. The interviewer then asked me to explain different possible time complexities, how they are calculated, and provided scenarios where different complexities occur. I was presented with two SQL queries: one using Joins and another using 3 nested subqueries. The interviewer also inquired about my adaptability skills and requested a real-life situation to demonstrate it. I ended this round by asking three questions.

Technical Round 3 (45 mins)

The final technical round started with an introduction about myself, covering both my technical and non-technical aspects. I was asked to explain the different DDL, DML, and DQL commands. I solved a DSA question which was a variation of Find the Index of the First Occurrence in a String. We discussed Database Normalization and its purpose, with a detailed explanation of 2NF and BCNF. I was asked to explain all 7 OSI Layers along with their associated protocols. Multithreading in Java was a topic of discussion, and I provided code examples for both Thread and Runnable Interfaces. We also covered Deadlocks, how to detect them, and the concept of Semaphores. The round concluded with questions on Triggers and PL/SQL. I asked one question at the end of this interview. Although for most people this was an HR round, it remained a technical round for me.

Verdict: Selected

I was successfully selected for the position.