Oracle interview experience Real time questions & tips from candidates to crack your interview
Intern
Oracle
3 rounds | 4 Coding
problems
Selected Interview preparation journey
Preparation
Duration: 4 months
Topics: Arrays, Linked List, Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic Programming
Tip 1 : Must do Previously asked Interviews Questions.
Tip 2 : Prepare OS, DBMS, OOPs, Computer Networks well.
Tip 3 : Prepare well for one project mentioned in the resume, the interviewer may ask any question related to the project, especially about the networking part of the project.
Application process
Where: Referral
Eligibility: 2+ years experience
Tip 1 : Highlight your major projects in your resume
Tip 2 : Do not put false information in your resume
Tip 3 : Make it simple, crisp and one page resume
Interview rounds
01
Round
Medium
Coding Test - Pen and paper
Duration107 minutes
Interview date17 Feb 2022
Coding problem1
This was online test having 4 sections. Each subset had its own time for solving.
1. MCQ Questions
There were 4 subsets:
English and Communication Skill Assessments(20 minutes)
Software Engineering Basics(45 minutes)
OS, OOPS, DBMS, Networking(22 minutes)
Data Structures and Aptitude(20 minutes)
Number Of MCQs - 65
02
Round
Medium
Video Call
Duration60 minutes
Interview date18 Feb 2022
Coding problem2
This was technical round taken by SDE at oracle having 3+ year of experience.
1. Best Time to Buy and Sell Stock
Moderate
20m average time
80% success
0/80
Asked in companies
You are given an array/list 'prices' where the elements of the array represent the prices of the stock as they were yesterday and indices of the array represent minutes. Your task is to find and return the maximum profit you can make by buying and selling the stock. You can buy and sell the stock only once.
Note:
You can’t sell without buying first.
For Example:
For the given array [ 2, 100, 150, 120],
The maximum profit can be achieved by buying the stock at minute 0 when its price is Rs. 2 and selling it at minute 2 when its price is Rs. 150.
So, the output will be 148.
Problem approach
The algorithtm runs through the array and checks for new minimums and new maximums. Whenever a new min is found, both min and max are overrided. Whenever a new maximum is found, it checks if we can get a higher profit with the current min and this new max. It only overrides profit if this is true.
class Solution {
public int maxProfit(int[] prices) {
int min = prices[0];
int max = prices[0];
int profit = 0;
for(int i = 1; i < prices.length; i++){
if (prices[i] <= min){
min = prices[i];
max = prices[i];
}
if(prices[i] > max){
max = prices[i];
if(profit < max - min)
profit = max - min;
}
}
return profit;
}
}
2. Merge Intervals
Moderate
20m average time
80% success
0/80
Asked in companies
You are given N number of intervals, where each interval contains two integers denoting the start time and the end time for the interval.
The task is to merge all the overlapping intervals and return the list of merged intervals sorted by increasing order of their start time.
Two intervals [A,B] and [C,D] are said to be overlapping with each other if there is at least one integer that is covered by both of them.
For example:
For the given 5 intervals - [1, 4], [3, 5], [6, 8], [10, 12], [8, 9].
Since intervals [1, 4] and [3, 5] overlap with each other, we will merge them into a single interval as [1, 5].
Similarly, [6, 8] and [8, 9] overlap, merge them into [6,9].
Interval [10, 12] does not overlap with any interval.
Final List after merging overlapping intervals: [1, 5], [6, 9], [10, 12].
Problem approach
/**
* @param {number[][]} intervals
* @return {number[][]}
*/
var merge = function(intervals) {
if(intervals.length < 2) return intervals;
intervals.sort((a,b) => a[0] - b[0]);
//console.log(intervals);
let result = [intervals[0]];
for (let i = 1; i < intervals.length; i++){
// make sure we are always pulling the last value from result array
let previousArr = result[result.length - 1];
// if the values need merging, update the previous value
if (previousArr[1] >= intervals[i][0]){
previousArr[1] = Math.max(previousArr[1], intervals[i][1]);
}else {
// otherwise add the value to the result array
result.push(intervals[i]);
}
}
return result;
}
03
Round
Easy
HR Round
Duration45 minutes
Interview date22 Feb 2022
Coding problem1
This was HR round taken by the senior manager at oracle. Interiewer was very friendly and supported during the interview.
1. Basic HR Questions
He started with his introduction first and asked me to introduce myself. then He asked some questions based on my resume. Then he asked me to explain one of my projects. I had explained to him that project. He asked me which one is a team project. I told him about one of my projects which was a team project. He then asked me to explain that project and then some general questions like conflicts in the team, problems faced during projects. After that, he explained a bit about Oracle and its current work. Why do you want to join oracle Do you have any offer in hand what are your strengths and weakness Will you leave oracle for higher pay Tell me about the most challenging project
Problem approach
Tip 1 : Make sure your resume is up-to-date
Tip 2 : Be confident and focus on your communication
Tip 3 : Prepare for the behavioural questions
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
How do you remove whitespace from the start of a string?
Choose another skill to practice
Similar interview experiences
SDE - 1
3 rounds | 2 problems
Interviewed by Oracle
Selected 
10749 views
0 comments
0 upvotes
SDE - 1
3 rounds | 5 problems
Interviewed by Oracle
Selected 0 views
0 comments
0 upvotes
Application Developer
3 rounds | 4 problems
Interviewed by Oracle
Rejected
1840 views
0 comments
0 upvotes
SDE - 1
3 rounds | 6 problems
Interviewed by Oracle
Rejected
3010 views
0 comments
0 upvotes
Companies with similar interview experiences
Intern
2 rounds | 2 problems
Interviewed by Microsoft
Selected 1499 views
0 comments
0 upvotes
Intern
2 rounds | 2 problems
Interviewed by Adobe
Selected 1019 views
0 comments
0 upvotes
Intern
2 rounds | 4 problems
Interviewed by Microsoft
Selected 0 views
0 comments
0 upvotes