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

Application Development Associate

Oracle
upvote
share-icon
4 rounds | 5 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 2 months
Topics: Data Structures, SQL, OOPS, System Design, Algorithms, Dynamic Programming, DBMS, OS
Tip
Tip

Tip 1 : Practice 100+ questions of medium difficulty
Tip 2 : Study SQL and DBMS concepts in depth. 

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

Tip 1 : Showcase only what you know.
Tip 2 : Have a proper format and at least 2 projects.

Interview rounds

01
Round
Medium
Video Call
Duration60 Minutes
Interview date15 Oct 2021
Coding problem2

Interviewer was straight forward, first he asked me "Tell me about yourself".
Then 2 coding questions of medium difficulty.

1. Largest subarray with equal number of 0s and 1s

Moderate
10m average time
85% success
0/80
Asked in companies
OraclePhonePeSAP Labs

You are given an array consisting of 0s and 1s. You need to find the length of the largest subarray with an equal number of 0s and 1s.

For example:

If the given array is: [0, 0, 1, 0, 1] The largest subarray would be: [0, 1, 0, 1] (last 4 elements) having length 4.
Problem approach

1) First, I provided the brute force solution - only discussion
2) Then, interviewer asked to optimize the solution. I used unordered map to solve it in O(n) time complexity. He was satisfied with this approach.

Try solving now

2. Sort Elements By Frequency

Easy
15m average time
85% success
0/40
Asked in companies
HSBCCIS - Cyber InfrastructureOracle

You are given a list of a repeated set of integers. Your task for the problem is to return a list of the given elements in decreasing sorted order of their frequency of repetition in the given list with the element with the highest frequency of repetition first and so on.

Note :
If two numbers have the same frequency then keep the one that was present before the other in the original given list (array) first.
For Example :
Input:  arr[] = {2, 5, 2, 8, 5, 6, 8, 8}
Output: arr[] = {8, 8, 8, 2, 2, 5, 5, 6}

Explanation :
When you sort the array based on the decreasing order of the frequency of repetition of integers in the original array, 
you’ll find that the element ‘8’ is the integer with the most repeated values therefore it would be arranged first after which since both 2 and 5 have the same number of repeated 
values in the original array but since the 2 arrived first so we will first arrange 2 and then 5 in our resultant array, while would be the last element after sorting here.
Problem approach

1) I used unordered map to store frequency of elements.
2) Then sorted this map according to the requirement.

Try solving now
02
Round
Medium
Video Call
Duration45 Minutes
Interview date19 Oct 2021
Coding problem1

In this round, Interviewer asked SQL and DBMS in depth.

1. DBMS Question

ACID properties, Normalization.
SQL JOINS queries. Asked me to write queries.

Problem approach

Tip 1: Revise DBMS concepts as much as possible.
Tip 2: Practice SQL queries, specially JOINS - all types (Inner, outer, left, right, left outer etc ...)

03
Round
Medium
Video Call
Duration60 Minutes
Interview date19 Oct 2021
Coding problem1

Asked to design system similar to LinkedIn.

1. System Design Question

LinkedIn System Design.

Problem approach

Tip 1: Start with basic requirement any system design need. ( Components, Features etc...)
Tip 2: Discuss with interviewer about your approach
Tip 3: In system design round, basically, the interviewer is looking for these things - 
1) how you are approaching the question.
2) What technologies you want to use.
3) how much knowledge you have regarding the system design concepts like - load balancing, caching, rate limiting, databases etc...

04
Round
Easy
HR Round
Duration45 minutes
Interview date19 Oct 2021
Coding problem1

Normal Behavioral questions and some puzzles.

1. Basic HR questions

How to make 100 by using four 7s? 

Normal behavioral questions like - why do you want to join Oracle, strengths and weakness, last company work and projects.

Problem approach

Tip 1: Solve as many puzzles as you can.
Tip 2: interviewbit site has many puzzles.

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
Application Developer
3 rounds | 4 problems
Interviewed by Oracle
1840 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 6 problems
Interviewed by Oracle
3010 views
0 comments
0 upvotes