Hi everyone, this topic is for sharing Preparation guidelines and interview experience for Oracle Intern
The Intern at Oracle involves a multi-stage assessment and interview process, designed to evaluate both technical skills and business proficiency. Below is a summary of the process and key points from the interviews you provided:
Assessment Test Rounds:
Round 1: Aptitude Test
Basic math and English questions (arithmetic, grammar, etc.).
Round 2: Coding Test
Write a program to calculate the final score in a cricket match given the number of deliveries; each delivery yields 0, 1, or 2 runs.
Round 3: Assignment
There are 1 million random numbers with one missing; find the missing number and discuss the algorithm and complexities.
Interview Rounds:
Technical Round (DSA – Stack & Sliding Window)
Longest Valid Parentheses.
Find the maximum number in all subarrays of length k (sliding window maximum).
Technical Round (Matrix/Traversal)
Spiral Matrix traversal.
Technical Round (Strings & Projects)
Write a program to remove/separate special characters from a string.
Discussion on personal projects and individual contributions.
Technical Round (OOP)
Questions on OOP concepts.
What is function overloading and overriding?
Technical Round (General)
Basic technical questions (unspecified by candidate).
HR Round
Questions around resume and extracurricular/extra activities.
Interview Preparation Tips:
Practice data structures and algorithms, especially stacks, sliding window techniques, and matrix traversal.
Focus on writing clean, efficient code and be ready to explain time and space complexity.
Revise OOP concepts thoroughly (polymorphism, encapsulation, inheritance, abstraction), including overloading vs overriding.
Practice string manipulation and loop-based coding questions.
Brush up on debugging approaches and common pitfalls.
Review database fundamentals; revise MySQL basics.
Prepare for aptitude (basic math) and English (grammar/comprehension).
Be ready to discuss your projects and extracurricular activities clearly, focusing on roles, responsibilities, and impact.
Technical/DSA/Programming
Longest Valid Parentheses.
Find the maximum in each subarray of size k (sliding window maximum).
Traverse/print a matrix in spiral order.
Given 1 million random numbers with one missing, find the missing number.
Write a program to compute the final cricket score given N deliveries where each ball yields 0, 1, or 2 runs.
Write a program to remove/separate special characters from a string.
Explain your algorithm and analyze its time and space complexity.
Basic technical questions (unspecified).
OOP/Conceptual
Explain core OOP concepts.
What is function overloading and overriding? Compare and provide examples.
Projects/Resume-based Technical
Discuss your personal projects: objectives, tech stack, your contributions, challenges faced, and outcomes.
Find the maximum number in the subarrays of length k.
Your Approach:
For the first question, I used a stack-based approach to track valid parentheses pairs and calculate the maximum length.
For the second question, I implemented a sliding window technique to efficiently find the maximum in each subarray.
Outcome: Passed to the next round.
Round 2 - Technical Round:
Questions Asked:
Spiral Matrix
Your Approach:
I broke down the problem into layers and iterated through each layer to traverse the matrix in a spiral order.
Outcome: Successfully cleared the round.
Preparation Tips:
Practice data structures and algorithms, especially stack, sliding window, and matrix traversal problems.
Focus on problem-solving techniques and time complexity optimization.
Conclusion:
The interview process was challenging but fair. I felt well-prepared for the technical rounds, and practicing similar problems beforehand helped me perform confidently. For future candidates, I recommend solving a variety of problems to build a strong foundation in algorithms and data structures.
Application Process: Applied through campus placement in August 2024.
Interview Rounds:
Round 1 - Aptitude Test:
Questions Asked: Basic aptitude questions.
Your Approach: Solved the questions systematically, focusing on accuracy.
Outcome: Cleared the round.
Round 2 - Communication Round:
Questions Asked:
Basic English questions.
A topic was provided, and I had to speak on it.
Your Approach: Spoke clearly and confidently, ensuring my points were well-structured.
Outcome: Successfully advanced to the next round.
Round 3 - Technical Round:
Questions Asked:
SQL syntax and the difference between HAVING and WHERE clauses.
Difference between array and linked list, and stack and queue.
Your Approach: Explained the concepts with examples and practical use cases.
Outcome: Cleared the technical round.
Round 4 - HR Round:
Questions Asked:
“Tell me about yourself.”
“Why do you want to join this role?”
Your Approach: Gave a concise introduction and aligned my goals with the role.
Outcome: Cleared the HR round and secured the internship.
Preparation Tips:
Practice aptitude questions from standard resources.
Brush up on SQL and basic data structures.
Prepare a clear and concise self-introduction.
Conclusion:
The interview process was smooth and well-structured. Focusing on clarity and confidence in communication helped me perform well. For future candidates, I’d recommend thorough preparation of technical concepts and practicing speaking on random topics to ace the communication round.
Application Process: The application process involved two interview rounds: an aptitude test followed by an HR round.
Interview Rounds:
Round 1 - Aptitude Test:
Questions Asked: Verbal reasoning questions were included in this round.
Your Approach: I focused on practicing verbal reasoning questions beforehand to ensure I could tackle them efficiently during the test.
Outcome: Successfully cleared the aptitude test and moved on to the next round.
Round 2 - HR Round:
Questions Asked:
Technical and programming-related questions.
Questions about my resume.
Your Approach: For the technical questions, I revised key programming concepts and projects I had worked on. For the resume-related questions, I made sure to highlight my relevant skills and experiences.
Outcome: The HR round went well, and I received positive feedback.
Preparation Tips:
Practice verbal reasoning questions thoroughly for the aptitude test.
Revise technical concepts and be prepared to discuss your resume in detail.
Conclusion:
Overall, the interview process was smooth and well-structured. Preparing in advance for both the aptitude test and the HR round helped me perform confidently. My advice to future candidates is to focus on understanding the basics and being clear about the details mentioned in your resume.
Application Process: I applied through my college’s campus placement process in February 2017.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked:
Everything related to my previous projects, including why we chose the technology and how we implemented it.
Normalization of a database to BCNF.
Difference between the ‘having’ clause and ‘where’ clause in MySQL.
Various DBMS queries.
Your Approach: I focused on explaining my projects in detail, emphasizing the thought process behind the technology choices and implementation. For technical questions, I tried to provide clear and concise answers, drawing from my coursework and practical experience.
Outcome: I passed this round and moved on to the next.
Round 2 - Aptitude Test:
Duration: 20 minutes
Total Questions: 25
Your Approach: I tackled the questions systematically, prioritizing those I was most confident about to maximize efficiency within the time limit.
Outcome: Successfully cleared the test.
Preparation Tips:
Focus on understanding your previous projects thoroughly, as interviewers often dive deep into them.
Brush up on fundamental database concepts like normalization, SQL clauses, and queries.
For aptitude tests, practice time management to ensure you can answer as many questions as possible within the given time.
Conclusion:
Overall, the interview process was a great learning experience. The key takeaway for me was the importance of being able to articulate my project work clearly and confidently. While technical knowledge is essential, demonstrating a willingness to learn and adapt can also make a strong impression. For future candidates, I’d advise staying calm, being honest about what you know, and showing enthusiasm for the role.
Application Process: Applied through campus placement.
Interview Rounds:
Round 1 - Coding Test:
Questions Asked:
DSA-based question.
REST API-related question.
SQL query-based question (hosted on HackerEarth).
Your Approach: Focused on solving the DSA question first, then moved to the REST API and SQL query. Practiced similar problems beforehand.
Outcome: Cleared the round.
Round 2 - One-on-One Technical Interview:
Questions Asked:
Linked list problem.
LIS/DP problem.
Java OOPs concepts.
Database-related questions.
Your Approach: Explained the logic for the linked list and DP problem clearly. For OOPs and DB, relied on fundamental concepts.
Outcome: Cleared the round.
Preparation Tips:
Be confident during the interview.
Practice DSA, OOPs, and database concepts thoroughly.
Solve problems on platforms like HackerEarth to get comfortable with coding tests.
Conclusion:
Overall, the interview process was smooth. I could have prepared more for the REST API question in the coding round. My advice to future candidates is to focus on all aspects of the role, including APIs and databases, not just DSA.
Application Process: I applied through campus placement before March 2023.
Interview Rounds:
Round 1 - Aptitude Test:
Questions Asked: Basic math problems and English-related questions.
Your Approach: I brushed up on basic arithmetic and grammar rules beforehand.
Outcome: Cleared the round successfully.
Round 2 - Coding Test:
Questions Asked: Write a program to calculate the final score in a cricket match where the number of deliveries is the input, and in each ball, a batsman can score either 0, 1, or 2.
Your Approach: I used a loop to iterate through each delivery and summed up the scores based on the input.
Outcome: Passed this round.
Round 3 - Technical Round (1):
Questions Asked:
Write a program to separate a string from special characters.
General questions about personal projects.
Your Approach: For the string separation, I used regular expressions. For the projects, I explained my contributions and learnings clearly.
Outcome: Advanced to the next round.
Round 4 - Technical Round (2):
Questions Asked:
Questions about OOPs concepts.
What is function overloading and overriding?
Your Approach: I explained OOPs principles with examples and differentiated between overloading and overriding.
Outcome: Cleared the technical rounds.
Round 5 - HR Round:
Questions Asked: General questions about extracurricular activities mentioned in the resume.
Your Approach: I highlighted my leadership and teamwork experiences.
Outcome: Received positive feedback and moved forward in the process.
Preparation Tips:
Practice basic math and English for aptitude tests.
Brush up on coding problems, especially string manipulation and loops.
Revise OOPs concepts thoroughly.
Be ready to discuss personal projects and extracurricular activities confidently.
Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared for the technical rounds, but I could have practiced more coding problems under time constraints. For future candidates, I’d recommend focusing on core programming concepts and being clear about your projects and experiences.
Application Process: I applied through campus placement and was interviewed before March 2023.
Interview Rounds:
Round 1 - Aptitude Test:
Questions Asked: Basic math problems and English-related questions.
Your Approach: I brushed up on basic arithmetic and grammar rules beforehand.
Outcome: Cleared the round successfully.
Round 2 - Coding Test:
Questions Asked: Write a program to calculate the final score in a cricket match where the number of deliveries is the input, and in each ball, a batsman can score either 0, 1, or 2 runs.
Your Approach: I used a loop to iterate through each delivery and summed up the runs based on the input.
Outcome: Passed this round.
Round 3 - Technical Round (1):
Questions Asked:
Write a program to separate a string from special characters.
General questions about my personal projects.
Your Approach: For the first question, I used string manipulation to filter out special characters. For the second, I explained my projects in detail, focusing on my contributions.
Outcome: Advanced to the next round.
Round 4 - Technical Round (2):
Questions Asked:
Questions about OOPs concepts.
What is function overloading and overriding?
Your Approach: I explained OOPs principles clearly and gave examples for function overloading and overriding.
Outcome: Cleared this round as well.
Round 5 - HR Round:
Questions Asked: General questions about extra activities mentioned in my resume.
Your Approach: I highlighted my extracurricular activities and how they contribute to my overall personality.
Outcome: Received positive feedback and moved forward in the process.
Preparation Tips:
Brush up on basic aptitude topics like math and English.
Practice coding problems, especially string manipulation and loops.
Revise OOPs concepts thoroughly.
Be ready to discuss your projects and extracurricular activities in detail.
Conclusion:
Overall, the interview process was smooth and well-structured. The technical rounds were challenging but manageable with proper preparation. I could have practiced more coding problems to feel even more confident. My advice to future candidates is to focus on core concepts and be clear about your projects and experiences.