Oracle interview experience Real time questions & tips from candidates to crack your interview
Quality Analyst
Oracle
3 rounds | 6 Coding
problems
Selected Interview preparation journey
Journey
Starting with a passion for AI/ML, I pursued a Computer Science degree, interned at DRDO, and worked on challenging projects in Computer Vision. Continuously learning and improving, I honed my problem-solving skills. This journey, filled with dedication and creativity, has led me to this job interview, where I am eager to contribute and grow further. My story demonstrates that perseverance and continuous learning can open doors to exciting opportunities.
Application story
On campus, I just submitted my resume.
An online assessment is conducted before the interviews:
1 DSA question (medium level, involving binary search on answers).
20 technical questions (covering OS, DBMS, CN, and other CS fundamentals).
15 general aptitude and communication questions.
Why selected/rejected for the role?
I was selected for the role due to my strong technical foundation, hands-on experience with real-world projects, and effective communication skills. My internship at DRDO demonstrated my ability to tackle complex problems creatively. My passion for AI/ML and commitment to continuous learning made me a great fit for the team.
Preparation
Duration: 3 months
Topics: Data Structures, OOPS, DBMS, SQL, OS, CN, ML
Tip 1: Complete at least two live projects.
Tip 2: Practice top interview questions.
Tip 3: Prepare CS subjects thoroughly.
Application process
Where: Campus
Eligibility: 7.5 CGPA
Tip 1: Only include skills on your resume that you are confident in.
Tip 2: Include projects related to the job description.
Interview rounds
01
Round
Medium
Online Coding Interview
Duration140 minutes
Interview date23 Aug 2024
Coding problem1
Online Assessment: (6:00 PM - 6:30 PM login window) (140-minute test)
Round 1: HackerRank Test
- 1 DSA question (medium level, involving binary search on answers)
- 20 technical questions (covering OS, DBMS, CN, and other CS fundamentals)
- 15 general aptitude and communication questions
1. Sort Linked List
Moderate
20m average time
80% success
0/80
Asked in companies
Given a Linked List, the task is to sort this Linked List in ascending order.
Problem approach
Step 1: Sort the linked list using bubble sort.
Step 2: The interviewer asked me to optimize the solution.
Step 3: I then provided a solution using merge sort, and the interviewer was pleased.
02
Round
Medium
Face to Face
Duration50 minutes
Interview date4 Sep 2024
Coding problem4
Round 1 (Technical – 50 Minutes):
The interviewer asked me to introduce myself and suggested addressing him by his name rather than "Sir" or "Madam." He confirmed Java as my primary language.
DSA: The interviewer concluded by asking if I had any questions. To build rapport, I asked:
- What are some common mistakes freshers often make, and how can I avoid them?
- What do you see as Oracle's future?
1. Java Questions:
- Explain heap and stack memory. (Learn)
- What are memory-related errors in Java (e.g., StackOverflowError and OutOfMemoryError)?
- Explain garbage collection. (Learn)
- What is static and dynamic binding? (Learn)
- Discuss the independence of JVM and Java's platform. (Learn)
- Provide an example of a singleton class. (Learn)
- What are JAR files? (Learn)
2. DBMS and SQL:
- What is a table and a view? (Learn)
- Explain RDBMS and SQL commands: DDL, DML, DCL, and TCL. (Learn)
- What is the difference between DROP, TRUNCATE, and DELETE commands? (Learn)
- Explain the CAP theorem and its trade-offs. (Learn)
- What is the difference between 3NF and BCNF? (Learn)
- Given 2-3 tables, I was asked to write SQL queries using joins and basic subqueries.
3. DSA
- Sort a linked list. I explained the merge sort approach.
- I then explained the intuition behind merge sort and was asked to analyze its time complexity.
- Why is the time complexity of binary search O(log N) and not N/2?
03
Round
Medium
Face to Face
Duration50 minutes
Interview date4 Sep 2024
Coding problem1
Projects, Design.
1. DBMS
- ER diagram
- Scheme design
- Normalization
- Explain REST with examples. (Learn)
- Various HTTP requests and CRUD operations
- Differences between PUT and POST, and write POST method. (Learn)
- Discussion about status codes. (Learn)
Problem approach
Tip 1: Review CS subjects.
Tip 2: Highlight projects on your resume.
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
What is recursion?
Choose another skill to practice
Similar interview experiences
Server Technology Engineer
2 rounds | 3 problems
Interviewed by Oracle
Selected 
1974 views
0 comments
0 upvotes
Associate Consultant
3 rounds | 3 problems
Interviewed by Oracle
Selected 918 views
0 comments
0 upvotes
Software Engineer
3 rounds | 5 problems
Interviewed by Oracle
Selected 1077 views
0 comments
0 upvotes
SDE - 1
3 rounds | 5 problems
Interviewed by Oracle
Rejected
1691 views
0 comments
0 upvotes