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

SDE - 1

Oracle
upvote
share-icon
2 rounds | 7 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 3 Months
Topics: Cloud, Algorithms, OOPS, Problem Solving, C language
Tip
Tip

Tip 1 : Evaluate job description
Tip 2 : Practice Mock interviews
Tip 3 : Do atleast 2 projects

Application process
Where: Other
Eligibility: No criteria
Resume Tip
Resume tip

Tip 1 : Keep Your Experience Recent and Relevant
Tip 2 : Skills are Equally as Important to mention

Interview rounds

01
Round
Hard
Online Coding Interview
Duration60 Minutes
Interview date4 Jan 2022
Coding problem6

- In Morning 
- Environment was good.
- No other activity
- Interviewer was good

1. DBMS Question

Q- 
Section (sect name, wing, expenses) and Student (student_ID, name, sect name, fees).
Here in both of these relations, the sect_name attribute appears commonly. In this case, using common attributes in the relation schema is a way in which we can relate the ___________ relations.

a. Tuple of common
b. Attributes of common
c. Attributes of distinct
d. Tuple of distinct

Problem approach

Tip 1 : Practice Normalization
Tip 2 : Practice Basic concepts 
Answer- d(Tuple of distinct)

2. OS Question

The operating system maintains a ______ table that keeps track of how many frames have been allocated, how many are there, and how many are available.
a) memory
b) mapping
c) page
d) frame

Problem approach

Tip 1 : Practice memory
Tip 2 : Practice mapping by Galvin Book
Ans - d(Frame)

3. Perfect Rectangle

Moderate
20m average time
85% success
0/80
Asked in companies
AppleOracleSamsung

You are given N rectangles whose sides are aligned with the x-axis and the y-axis. Each rectangle is represented by 4 integers [ a, b, c ,d ]. Here, (a, b) are x and y coordinates of the bottom left corner, and (c, d) are x and y coordinates of the top right corner.

You need to find if they all together form a rectangular region cover.

For Example :
If the given rectangle is [1, 1, 3, 2]. It means the bottom left corner is at [1, 1] and the top right corner is at [3, 2]. Hence, the top left corner is at [1, 2] and the bottom right corner is at [3, 1].

For the given figure is for N = 4, rectangle[0] = [1, 1, 4, 5], rectangle[1] = [4, 1, 6, 2], rectangle[3] = [4, 2, 6, 5], rectangle[4] = [6, 1, 8, 5].

alt text

As they all form a big rectangle [1, 1, 8, 5]. So, the answer is 1.

Note :

Two integers are used to represent Point - x and y coordinates.

Two points are used to represent a Rectangle - Bottom left corner and top right corner.
Try solving now

4. Chocolate Pickup

Hard
29m average time
0/120
Asked in companies
AppleOracleChegg Inc.

Ninja has a 'GRID' of size 'R' X 'C'. Each cell of the grid contains some chocolates. Ninja has two friends Alice and Bob, and he wants to collect as many chocolates as possible with the help of his friends.

Initially, Alice is in the top-left position i.e. (0, 0), and Bob is in the top-right place i.e. (0, ‘C’ - 1) in the grid. Each of them can move from their current cell to the cells just below them. When anyone passes from any cell, he will pick all chocolates in it, and then the number of chocolates in that cell will become zero. If both stay in the same cell, only one of them will pick the chocolates in it.

If Alice or Bob is at (i, j) then they can move to (i + 1, j), (i + 1, j - 1) or (i + 1, j + 1). They will always stay inside the ‘GRID’.

Your task is to find the maximum number of chocolates Ninja can collect with the help of his friends by following the above rules.

Example:
Input: ‘R’ = 3, ‘C’ = 4
       ‘GRID’ = [[2, 3, 1, 2], [3, 4, 2, 2], [5, 6, 3, 5]]
Output: 21

Initially Alice is at the position (0,0) he can follow the path (0,0) -> (1,1) -> (2,1) and will collect 2 + 4 + 6 = 12 chocolates.

Initially Bob is at the position (0, 3) and he can follow the path (0, 3) -> (1,3) -> (2, 3) and will colllect 2 + 2 + 5 = 9 chocolates.

Hence the total number of chocolates collected will be 12 + 9 = 21. there is no other possible way to collect a greater number of chocolates than 21.
Try solving now

5. One iteration

Easy
10m average time
90% success
0/40
Asked in companies
OracleUberAmazon

Alice loves to give challenging tasks to Bob. This time, Alice gave Bob an array ‘A’ of ‘N’ distinct integers and asked him to find the maximum sum Bob can make by taking two elements from this array. To make this challenging, Alice asked Bob to find the answer by traversing the array only once.

As always, Bob asked you to help him do the task by traversing the array only once.

Try solving now

6. Coin Game

Easy
15m average time
85% success
0/40
Asked in companies
SalesforceOracleD.E.Shaw

Wong is hungry and wants to eat tuna melt. He checks his pocket and finds that he has only a buck left. He asked Dr. Strange to lend him some money, for which Strange agrees but to get the money, Wong has to beat Strange in a game of coins. The game will be played by two players. Being kind enough Strange allows Wong to play first. Now, Strange arranges N coins in a row. Each coin is associated with a value. In his turn, every player can remove only one coin from either end. Once a player removes a coin, it can not be placed back into the row. At the end when all coins are removed, the player with the maximum value of coins wins. Wong will only get money if he wins the game. Wong knows that he can not beat sorcerer supreme, so he asked for your help.

You are given an array of integers, say, ‘ARR’ of size ‘N’ containing the values associated with ‘N’ coins. Your task is to determine the maximum value of coins you can obtain by following two rules:

a) Both players play in alternate turns and they can remove only one coin in their turn.
b) Any player can remove coins only from either of the two ends of ‘ARR’.

Note:

There can be more than one set of coins with maximum value.

For example:

a) Consider 3 coins are placed with values [10, 20, 30]: Wong removes 30, then Strange removes 20, then Wong removes 10. Now all coins are taken, and Wong has coins with value 40 and he wins.

b) Consider 1 coin is placed with value [100]: Wong removes the coin and no other coin is left. So, Wong wins with value 100.

Note:

a) The game only ends when NO MORE COIN IS LEFT to play with.

b) If a game ends in a draw, Wong is declared the winner. 
Try solving now
02
Round
Medium
HR Round
Duration30 Minutes
Interview date28 Jan 2022
Coding problem1

- Morning time
- Environment was good.
- No
- Interviewer was good

1. Basic HR Questions

- Tell me about yourself 

- What did you like most about the job description? 

- What experience do you have that would be relevant to this role? 

- What experience do you have that would be relevant to this role? 

- What experience do you have that would be relevant to this role?

Problem approach

Tip 1 : Practice communication
Tip 2 : Hands on vocabulary
Tip 3 : Should know the services provided by company

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