Oracle On-Campus ASE Interview Experience (2024 Batch)

How the process went

1. Online Assessment

   A 100-minute HackerRank test with 10 aptitude questions, 10 English verbal reasoning questions, one coding problem, and one REST API question. The candidate described this round as easy and straightforward.

2. Technical Round 1 (40 minutes)

   Covered Git/GitHub, version control concepts, an HTML/CSS layout question, one DSA problem, sorting techniques, and tree storage approaches.

3. Technical Round 2 (70 minutes)

   A resume and project deep dive combined with machine learning, SQL, and behavioral questions; the candidate noted this round ran about 45 minutes before moving into questions about higher studies and internships.

4. Technical Round 3 (45 minutes)

   Covered databases, networking, and Java concurrency. The candidate noted this slot was typically the HR round for other candidates, but the interviewer kept it technical.

5. Outcome

   The candidate was selected.

Online Assessment

Aptitude, verbal reasoning, coding, and API design (HackerRank) · 100 minutes

• 10 aptitude questions
• 10 English verbal reasoning questions
• Coding question: Lexicographically Largest Subsequence
• REST API question on maximum transfer, similar to typical HackerRank API-style problems

Candidate described this round as easy and straightforward.

Technical Round 1

Version control, front-end basics, sorting, and data structures · 40 minutes

• Explain GitHub and its commands
• Explain the different types of version control systems
• List and explain Git commands
• What should be done when merge conflicts occur in GitHub
• HTML/CSS: given three overlapping boxes, make the box under the mouse pointer come to the front and return to its original position on mouse-out
• DSA: LeetCode 42 (Hard), Trapping Rain Water
• Explain different sorting techniques, including writing and dry-running Heap Sort
• Discuss different ways to store a tree

Candidate asked two questions of the interviewer at the end.

Technical Round 2

Resume/project deep dive, machine learning concepts, SQL, and behavioral questions · 70 minutes

• Walkthrough of each project listed on the resume
• Machine learning/data science questions tied to the candidate's projects, including dataset-based SQL questions
• Explain precision, recall, MSE, CNN, KNN, and clustering, with real-world examples
• Questions related to electives taken (Data Mining and Cryptography)
• Plans for higher studies
• Why the candidate had not completed any internships
• Explain different time complexities and the scenarios that produce them
• Write a SQL query using joins
• Write a SQL query using three nested subqueries
• Describe a real-life situation that shows adaptability

Candidate asked three questions of the interviewer at the end.

Technical Round 3

Databases, networking, and Java concurrency; doubled as the HR round for this candidate · 45 minutes

• Self-introduction, both technical and non-technical
• Explain DDL, DML, and DQL commands
• DSA: a variation of Find the Index of the First Occurrence in a String
• Explain normalization, including 2NF and BCNF
• Explain all seven OSI layers and their associated protocols
• Explain multithreading in Java, including code for the Thread class and the Runnable interface
• Discuss deadlocks and how to detect them
• What are semaphores
• Explain triggers and PL/SQL

Candidate asked one question at the end.

This round was typically the HR round for most candidates, but the interviewer used it as a technical round in this case.

Source

The questions and process facts come from the candidate's public write-up, linked below. The retelling above is our own summary.