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

Software Developer

Oracle
upvote
share-icon
3 rounds | 6 Coding problems

Interview preparation journey

expand-icon
Journey
I started my coding journey with primary C language with other basic kinds of stuff like how to work with arrays and loops. after that, I focused 6 months on data structure and algorithm, and during these 6 months, I started giving contests on CodeChef and Codeforces. Initially, I could not do well, but after giving some contests, I could perform well.
Application story
This was an on-campus opportunity. I applied through the college placement cell. The first resume shortlisting was performed. After the online test 50 candidates were selected for interviews.
Why selected/rejected for the role?
I didn't have much knowledge of software development. may be they require people with good project experience.
Preparation
Duration: 6 Months
Topics: Data Structure, Algorithm, OOPS, DP, Puzzles
Tip
Tip

Tip 1 : Don't waste much time on easy questions
Tip 2 : If you can't make a solution to the problem. Check out other's solution
Tip 3 : Do some good projects

Application process
Where: Campus
Eligibility: 1) 7 CPI and above 2) No backlogs in any semester
Resume Tip
Resume tip

Tip 1 : Write only those skills in which you are confident
Tip 2 : Have a variety of achievements in your resume

Interview rounds

01
Round
Easy
Online Coding Interview
Duration105 Minutes
Interview date3 Aug 2022
Coding problem2

This was an online round including 
1 coding questions.
1 REST API problem
1 Sql query problem
6 MCQ's

1. Longest Repeating Substring

Moderate
10m average time
90% success
0/80
Asked in companies
IBMMakeMyTripCIS - Cyber Infrastructure

You are given a string 'str' of length 'N'. You can perform at most 'k' operations on this string. In one operation, you can choose any character of the string and change it to any other uppercase English alphabet character.


Return the length of the longest substring containing same characters after performing the above operations.


For example :

Input:
str="AABC"  k=1

Output:3

Explanation: Replace 'B' with 'A', we will get "AAAC" and the longest substring with same character is "AAA" of length 3.
Try solving now

2. SQL Question

Given a table with 4 fields
1. ID Integer
2. Name String
3. Months Integer
4. Hackos Integer

Write a query to print the names of all the hackers who have earned more than 100 hackos in less than 10 months

Problem approach

Tip 1 : Do practice SQL queries

02
Round
Medium
Video Call
Duration60 Minutes
Interview date6 Aug 2022
Coding problem2

Interviews were conducted in online mode on zoom meeting.

1. Permutations of a String

Moderate
15m average time
85% success
0/80
Asked in companies
MakeMyTripDisney + HotstarOla

You are given a string 'STR' consisting of lowercase English letters. Your task is to return all permutations of the given string in lexicographically increasing order.

String A is lexicographically less than string B, if either A is a prefix of B (and A ≠ B), or there exists such i (1 <= i <= min(|A|, |B|)), that A[i] < B[i], and for any j (1 <= j < i) A[i] = B[i]. Here |A| denotes the length of the string A.

For example :

If the string is “bca”, then its permutations in lexicographically increasing order are { “abc”, “acb”, “bac”, “bca”, “cab”, “cba” }.
Note:
Given string contains unique characters.
Try solving now

2. Tic Tac Toe Winner

Hard
40m average time
70% success
0/120
Asked in companies
Media.netCerence IncZeta

Ninja is bored and hence started playing tic tac toe with his friend. As always he started losing the game. So he approaches you to find the optimal move he needs to play at a given moment so that he can defeat his friend.

You are given the current state of the game with a 3x3 grid, of which some squares are filled with 'X', some are filled with ‘O’ and the rest are filled with ‘_’ which means that this square is empty. You need to find the best possible score our ninja can get and the position of the optimal move he should make. You always start first and your symbol is ‘X’. The scores are assigned as follows:

Win: 1

Draw : 0

Lose : -1

For Example:
Suppose the board looks as follows: 

X O X
O O X
_ _ _


We can see that if we put X at positions 3, 3 in the grid we win straightaway. Hence the best possible score is 1 (Win). If we put our symbol anywhere else we will not be able to achieve the desired score.
Note :
If there are multiple positions leading to the same score, choose the position with the minimum row. If there are still multiple positions, choose the one with the minimum column.
Try solving now
03
Round
Medium
Video Call
Duration60 Minutes
Interview date6 Aug 2022
Coding problem2

Interviews were conducted in online mode on zoom meeting.

1. Sudoku Solver

Hard
25m average time
75% success
0/120
Asked in companies
OlaMicrosoftAmazon

You have been given a 9x9 2d integer matrix 'MAT' representing a Sudoku puzzle. The empty cells of the Sudoku are filled with zeros, and the rest of the cells are filled with integers from 1 to 9. Your task is to fill all the empty cells such that the final matrix represents a Sudoku solution.

Note:
A Sudoku solution must satisfy all the following conditions-
1. Each of the digits 1-9 must occur exactly once in each row.
2. Each of the digits 1-9 must occur exactly once in each column.
3. Each of the digits 1-9 must occur exactly once in each of the 9, 3x3 sub-grids of the grid.

You can also assume that there will be only one sudoku solution for the given matrix.
Problem approach

solved using backtracking

Try solving now

2. Minimum Knight Moves

Hard
0/120
Asked in companies
MathworksAmazonRupeek

You are given an infinite chessboard (ie: the x-coordinates and y-coordinates can be anything between -infinity to +infinity).

You have a knight placed at coordinates ‘(0, 0)’. Find the minimum number of steps needed to move the knight to ‘(X, Y)’.

The knight has 8 possible moves, each move is two units in a cardinal direction, then one unit in an orthogonal direction.

For example :

As depicted in the photo below, the knight currently at (0, 0) can move to any of the 8 positions: (1, 2), (2, 1), (2, -1), (1, -2), (-1, -2), (-2, -1), (-2, 1), (-1, 2).

Example :
If X = 1 and Y = -1, then we need to find out the minimum number of steps to move the knight from (0, 0) to (1, -1).

We need at least 2 steps to move the knight to the desired position.

First move: (0, 0) -> (2, 1) 

Second move: (2,1) -> (1, -1)

Here we can see that there are many ways, but we need at least 2 steps. Therefore we will return the value 2.
Try solving now

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
Server Technology Engineer
2 rounds | 3 problems
Interviewed by Oracle
1998 views
0 comments
0 upvotes
company logo
Associate Consultant
3 rounds | 3 problems
Interviewed by Oracle
940 views
0 comments
0 upvotes
company logo
Software Engineer
3 rounds | 5 problems
Interviewed by Oracle
1103 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
Software Developer
5 rounds | 14 problems
Interviewed by Microsoft
4029 views
1 comments
0 upvotes
company logo
Software Developer
6 rounds | 12 problems
Interviewed by SAP Labs
2912 views
0 comments
0 upvotes
company logo
Software Developer
3 rounds | 3 problems
Interviewed by Amazon
1271 views
0 comments
0 upvotes