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

SDE - 1

Oracle
upvote
share-icon
4 rounds | 6 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 6 months
Topics: Database management system, SQL, OOPS, C++, Operating System, Design and analysis of algorithms
Tip
Tip

Tip 1 : You should be familiar with every data structure and should be able to solve at least basic questions of it.
Tip 2 : Stack ,Linked lists, queue ,2 pointers, tree are topics from which questions are frequently asked.
Tip 3 : At least one project should be there in your resume that is good enough.

Application process
Where: Campus
Eligibility: B.Tech & M.Tech with specialization in CSE/ECE/EEE/IT/EIE/MCS (CS/IT); research students are not eligible. 7/10 and above or percentage equivalent 70% and above. No Active Backlogs in any semester.
Resume Tip
Resume tip

Tip 1 : Be honest with whatever you put in your resume. 
Tip 2 : You should have thorough knowledge of everything you put in your resume

Interview rounds

01
Round
Medium
Online Coding Interview
Duration120 minutes
Interview date3 Aug 2022
Coding problem2

The Online Test was scheduled on 3rd August, 2022 (Wednesday) from 03:00 p.m. to 05:00 p.m.

1. Remove Duplicates From String

Moderate
25m average time
0/80
Asked in companies
SquadstackAmazonGoldman Sachs

You are given a string (STR) of length N, consisting of only the lower case English alphabet.

Your task is to remove all the duplicate occurrences of characters in the string.

For Example:
If the given string is:
abcadeecfb

Then after deleting all duplicate occurrences, the string looks like this:
abcdef
Problem approach

Step 1 : Take a visited array to store whether a particular character has been visited or not and take a count array. Store the occurrences of all characters in that array. 
Step 2 : Traverse the string, decrease the count of that particular character .If the character is visited ,continue the loop.
Step 3 : If at a particular instance, the top element of stack is smaller than the current character, pop the characters from the stack till the count of the every top character of stack is greater than zero and make every character as non-visited.
Step 4 : push the current character of the string into a stack and mark it as visited.

Try solving now

2. Reverse Linked List

Moderate
15m average time
85% success
0/80
Asked in companies
WalmartHCL TechnologiesInfo Edge India (Naukri.com)

Given a singly linked list of integers. Your task is to return the head of the reversed linked list.

For example:
The given linked list is 1 -> 2 -> 3 -> 4-> NULL. Then the reverse linked list is 4 -> 3 -> 2 -> 1 -> NULL and the head of the reversed linked list will be 4.
Follow Up :
Can you solve this problem in O(N) time and O(1) space complexity?
Try solving now
02
Round
Easy
Online Coding Test
Duration60 minutes
Interview date9 Aug 2022
Coding problem1

Questions related to my project ,DBMS, OOPS were asked . 2 SQL queries were also asked.

1. Two Sum

Easy
10m average time
90% success
0/40
Asked in companies
MeeshoAdobeInfo Edge India (Naukri.com)

You are given an array of integers 'ARR' of length 'N' and an integer Target. Your task is to return all pairs of elements such that they add up to Target.

Note:

We cannot use the element at a given index twice.

Follow Up:

Try to do this problem in O(N) time complexity. 
Problem approach

Step 1: I first applied two nested for loops and checked for every element i and every element j if they add up to target. It was not good enough.
Step 2: Then I used map to store all the numbers and checked for every element if target - nums[i] is present in the map. The interviewer further added that consider the array is sorted.
Step 3: I then applied 2 pointer approach.

Try solving now
03
Round
Medium
Online Coding Test
Duration60 minutes
Interview date9 Aug 2022
Coding problem2

Questions related to my internship were asked. Ques from OOPS,DBMS were also asked.

1. Intersection of Two Linked Lists

Easy
25m average time
73% success
0/40
Asked in companies
OracleThought WorksIBM

You are given two Singly Linked Lists of integers, which may have an intersection point.

Your task is to return the first intersection node. If there is no intersection, return NULL.


Example:-
The Linked Lists, where a1, a2, c1, c2, c3 is the first linked list and b1, b2, b3, c1, c2, c3 is the second linked list, merging at node c1.

alt.txt

Problem approach

Step 1 : Find the length of both linked lists and take their difference 'd'
Step 2 : Move the larger node forward by 'd' steps
Step 3 : Now the starting point of both linked lists are equidistant from intersection ,so move both pointers together until the intersection is found.

Try solving now

2. First Missing Positive

Moderate
18m average time
84% success
0/80
Asked in companies
DunzoHikeSamsung

You are given an array 'ARR' of integers of length N. Your task is to find the first missing positive integer in linear time and constant space. In other words, find the lowest positive integer that does not exist in the array. The array can have negative numbers as well.

For example, the input [3, 4, -1, 1] should give output 2 because it is the smallest positive number that is missing in the input array.

Try solving now
04
Round
Medium
HR Round
Duration40 minutes
Interview date9 Aug 2022
Coding problem1

I was asked various HR questions related to my internship . I was put in various situations and asked how I'd deal with them. My fears and other such questions were asked.

1. Technical Questions

I was asked questions from DBMS,DS.

Egg dropping problem was asked as well. I was asked to find minimum eggs we would require in this problem.

Problem approach

Tip 1 : Do not pretend to be somebody else . Be honest with your replies.
Tip 2 : Go through some previously asked HR questions so that you get an idea what type of questions could be asked.
Tip 3 : Do not panic and try to be calm .

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
3010 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