Oracle Interview Experience for Summer Internship 2022

Last Updated : 25 Oct, 2022

Recently, Oracle came to our campus for an internship and placement. I am happy to tell you that I cracked this opportunity and I am here to share my experience throughout the hiring process.

Profile:

Server Technology – Project Intern
Applications Development – Project Intern

Courses Allowed:

Server Technology: B.Tech. – All
Applications Development: B.Tech. – All

Eligibility:

7 CGP and above
No backlogs in any Semester

Process:

Pre-Placement Talk
Resume Based Shortlisting
Online Test
Interviews

Job Location: Bangalore/Hyderabad

There were overall 4 online rounds conducted.

Online coding round
DSA round
Dsa + core
HR round

Round 1: This was online coding round of about 90 minutes and total 9 questions (6MCQ + 1 Coding qus + 1 API query + 1 Sql question), there were around three sets, and questions were of different difficulty level.

Coding question: https://www.geeksforgeeks.org/sum-xor-possible-subsets/

Mcq were quite easy, basic questions of dsa and c,c++.

I was able to solve 1 coding question and all 6 mcq, didn’t even touched other two questions

Around 67 students were shortlisted after this round I was lucky enough to be one of them.

Round 2(Technical Interview):

Tell me about yourself
What were the courses in your first and second year of college
Which language you are comfortable with? I replied C++.
Why you are not comfortable with java, there was a course of java in your third semester
Then he gave me a hackerrank link and I was supposed to write code there and run on test cases
The first question was: https://www.geeksforgeeks.org/decimal-equivalent-of-binary-linked-list/
The second question was swap values of two variables without using any function or any extra variable.

Round 3(Technical Interview):

Introduction

Given a even number n , print two prime numbers whose sum is equal to given number, if there are many combinations print first one.
- I first told her the brute force, then optimised it by using sieve. Problem link: https://www.geeksforgeeks.org/find-two-prime-numbers-with-given-sum
Then she asked me about sorting algorithms, she asked which is best and worst sorting algorithm and why, then she asked me about working of merge sort, quick sort.

Round 4(HR Round):

Tell me about yourself
- I gave my introduction
Why we should offer you this internship and not anyone else in this pool?
- Because I think i have the skills which are required for your job.
What skills do you have ?
- I have great problem solving skills, enthusiasm, open to learn new things.
What do you know about oracle, what does oracle do and who are its compititors?
- Oracle is a computer technology corporation best known for its software products and services like Java, MySql. Its competitors are IBM, Salesforce, Microsoft.
Why you chose oracle and not any other mnc?
- Because I think oracle has best work life balance and employee friendly culture among all its competitors.
What are the big changes in technology that affected your life style in last 5 years.
Then he gave me some situational questions like:
1. you are working on a project and there are three guys in your team how will you complete your project ?
2. There was a lazy guy in your team who didn’t did his part of work how will you react to this ?
3. Because of him you got D in your semester what will you do then, will you take him again in your team in next semester or you will remove him from your team ?
4. In next semester what precautions you will take to ensure that same mistake will not be repeated again?
There are 3 ants sitting on three corners of a triangle. All ants randomly pick a direction and start moving along edge of the triangle. What is the probability that any two ants collide?
Problem LInk: https://www.geeksforgeeks.org/puzzle-21-3-ants-and-triangle/
Then he asked me one dsa problem you are given an array of integers you need to tell the element with maximum frequency.
- Problem Link: https://www.geeksforgeeks.org/frequent-element-array/