Oracle interview experience Real time questions & tips from candidates to crack your interview

SDE - 1

Oracle
upvote
share-icon
4 rounds | 7 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 6 months
Topics: DSA - Graphs, Dynamic Programming, Binary Search, heaps, Trees, OOPs, DBMS, OS
Tip
Tip

Tip 1 : Start coding as soon as possible at least 3-4 months before starting of 3rd year in college.
Tip 2: If you are in 6th semester and placement session is near, then no worries you can still do just fine. Don't waste 
any time in unnecessary activities. Start doing coding or brush up your weak topics if you have already started it.
Tip 3 : Do not hesitate to look for solutions on YouTube or any other platform. Even if you solved a question then also 
try to look for other optimal solutions. It is very helpful during interviews.
Tip 4 : Try to do questions from leetcode, interviewbit (highly recommended).
Tip 5: Try to have at least 2 projects (1 major and 1 minor) or if you have 1 major project then it should be full fledged i.e. frontend backend fully implemented.

Application process
Where: Campus
Eligibility: CPI : 7 and above
Resume Tip
Resume tip

Tip 1 : Read your resume thoroughly. You should know everything mentioned in your resume.
Tip 2 : Try to put your resume more on technical side (try to include technical achievements)
Tip 3 : Try to be precise and keep it in single page only.

Interview rounds

01
Round
Medium
Online Coding Interview
Duration120 minutes
Interview date4 Aug 2022
Coding problem3

It was an online round. It started at around 2 pm on 4th August. It consist of 1 coding question, 1 sql query, 1 rest api related question and 6 mcqs related to dsa.

1. Minimum Steps

Moderate
20m average time
80% success
0/80
Asked in companies
DirectiOracleWells Fargo

You are given an array ‘ARR’ consisting of ‘N’ integers. Your task is to make all the numbers equal. You decrease one of the largest numbers present in the array into a number that is just lower than the maximum number in one step.

For example:
You are given ‘ARR’ = [5, 2, 3]
In the first step, you can change 5 to 3, so the new array is [3, 2,3].

In the second step, you can change the 3 to 2, then the array is [2, 2,3].

In the third step, you can change the 3 to 2, then the array is [2, 2, 2] 

Hence the answer is 3.
Problem approach

I applied bfs using priority queue. In queue, I stored current cell position and number of jumps till now. Priority queue pops elements on the basis of shortest number of moves till now. As soon as I encounter the last cell, I stopped and return the moves till now. Basically, it is Djikstra algorithm on matrix.

Try solving now

2. SQL Question

We have to write a query for the test case asked. It is a general query which one can practice from coding ninjas guided path for dbms.

Problem approach

Tip 1 : You should have good command on SQL.
Tip 2 : Practice SQL queries (I'd recommend to do it from coding ninjas guided path for DBMS).

3. Rest API

I don't exactly remember this question. But it was to write code to fetch data from given url and then perform some operations on that data to give required results. It was something related to http requests.

Problem approach

Tip 1 : Should have knowledge of handling requests in rest api.

02
Round
Easy
Video Call
Duration25 minutes
Interview date5 Aug 2022
Coding problem1

This round started at 10:30 am on 5th August and lasted for about 25 minutes. I gave this round from my hostel room.

1. Search an Element in an Array

Easy
15m average time
80% success
0/40
Asked in companies
GrabOracleCultfit

You have given a sorted array 'A' of 'N' integers.

Now, you are given 'Q' queries, and each query consists of a single integer 'X'. Your task is to check whether 'X' is present in array 'A' or not for each query. If 'X' exists in array 'A', you need to print 1 else print 0.

Note :

The given array is sorted in non-decreasing order. 
Try solving now
03
Round
Medium
Video Call
Duration50 minutes
Interview date5 Aug 2022
Coding problem2

This round began at 1:30 pm. It was also an online video call round. This round is a mix round. There was one coding question, some questions of memory and pointers, and puzzle.
 

1. Maximum Path Sum

Easy
0/40
Asked in companies
Goldman SachsMicrosoftOracle

You are given an n-ary tree consisting of ‘N’ nodes. Your task is to return the maximum sum of the path from the root to the leaf node.

For example:
For the given tree:

The path 1 -> 3 -> 7 produces the maximum i.e, 11.
Problem approach

I have solved this problem using recursion.

Try solving now

2. Puzzle Question

Given a 4 digit number, when it is multiplied by 4 the answer is reverse of original number. What is/are the possible number(s)?

04
Round
Easy
HR Round
Duration30 minutes
Interview date5 Aug 2022
Coding problem1

This round was the last round and easiest one. One just need to have proper communicating skills and they can easily make through this round. Interviewer was very nice and chill. There were project discussions and general conversations.

1. Technical Questions

I was asked to describe my internship project and my college project too. Then there were some general discussions. Some behavioural questions like : "Describe any event in your life after which your perspective towards life changed completely." and "Some example of leadership skills that you have shown in past."

Problem approach

Tip 1 : Must have proper and deep understanding of the project.
Tip 2 : Read your resume properly and thoroughly. You should mention only those things in resume which you can explain and have proper knowledge of that.
Tip 3 : Have confidence in yourself.

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
company logo
SDE - 1
3 rounds | 2 problems
Interviewed by Oracle
10749 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 5 problems
Interviewed by Oracle
0 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 6 problems
Interviewed by Oracle
3011 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 5 problems
Interviewed by Oracle
1728 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
SDE - 1
5 rounds | 12 problems
Interviewed by Amazon
115097 views
24 comments
0 upvotes
company logo
SDE - 1
4 rounds | 5 problems
Interviewed by Microsoft
58238 views
5 comments
0 upvotes
company logo
SDE - 1
3 rounds | 7 problems
Interviewed by Amazon
35147 views
7 comments
0 upvotes