Oracle | On Campus | Interview Experience | 2024 Batch

B. Tech - Tier 1 National Institute

All interviews offline except Online Assessment (OA).

Round 1: Online Assessment
Platform: HackerRank
Time: 100 minutes

10 Aptitude Questions
10 English Verbal Reasoning Questions
1 Coding Question: Lexicographically Largest Subsequence
1 Rest API Question - Maximum Transfer Similar to Hackkerank api questions
This round was easy and straightforward.

Interviews

Technical Round 1 (40 mins)

• The interviewer asked me to explain GitHub and its commands.
• Explain the different types of Version Control Systems (VCS).
• List and explain all the Git commands.
• What should be done when merge conflicts occur in GitHub?
• A question regarding HTML/CSS: Given three overlapping boxes, on moving the mouse pointer over one box, that particular box should come above, and on moving out, it should go back to the original place.
• One Data Structures and Algorithms (DSA) question was asked: LeetCode 42 Hard - Trapping Rain Water
• Explain different sorting techniques. The interviewer asked me to explain Heap sort by writing the code and doing a detailed dry run on it.
• Discuss different ways to store a Tree.
• I asked two questions at the end of the interview.

Technical Round 2 (70 mins)

• The interviewer reviewed my resume and asked me to explain each of my projects.
• Questions about Machine Learning/Data Science concepts were asked in detail related to my projects, including dataset based SQL questions.
• Questions about terms like Precision, Recall, MSE, CNN, KNN, and Clustering, along with real-world examples.
• Was asked to List the electives I have taken and was asked questions related to them (in my case, Data Mining and Cryptography) and questions were asked in it
  ------------------------ Till now it went on for 45 minutes -------------------------
• Asked about my plans for higher studies.
• Inquired about why I hadn't completed any internships so far (As I hadn't done any Internships)
• Asked me to explain different possible time complexities, how they are calculated, and provided scenarios where different time complexities occur.
• Was Presented with two SQL queries:
  -> One using Joins
  -> One using 3 nested subqueries
• Interviewer asked me about my adaptability skills and requested a real-life situation showing it.
• I asked three questions at the end of the interview.

Technical Round 3 (45 mins)

• An introduction about me, both technically and non-technically, was requested.
• Explain the different DDL, DML, and DQL commands.
• Solved a DSA question, a Variation of Find the Index of the First Occurrence in a String
• Discussed Normalization and its purpose.
• Detailed explanation of 2NF and BCNF was asked.
• Was asked to explain all 7 OSI Layers along with associated protocols.
• Explained Multithreading in Java, including codes for Thread and Runnable Interface.
• Discussed Deadlocks and how to detect them.
• What are Semaphores.
• Explain Triggers and PL/SQL
• I asked one question at the end.

This was a HR round for the majority of the people, but they kept a Technical Round for me.

Verdict: Selected