Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Oracle interview experience Real time questions & tips from candidates to crack your interview

SDE - 1

Oracle
upvote
share-icon
4 rounds | 5 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 1 month
Topics: Data Structures, OOPS, Algorithms, DBMS, OS
Tip
Tip

Tip 1 : Practice standard questions of data structures and algorithms
Tip 2 : Have good knowledge of DBMS
Tip 3 : PracticeSQL Queries

Application process
Where: Campus
Eligibility: Above 7 CGPA
Resume Tip
Resume tip

Tip 1 : Have some team projects
Tip 2 : Have a project on DBMS
Tip 3 : Don't put false things on resume, they ask each and everything.

Interview rounds

01
Round
Easy
Online Coding Interview
Duration60 minutes
Interview date12 Sep 2020
Coding problem0

Time restrictions were really hard.
You can not re-attempt any question.
You can't even re-visit any question.
They literally asked everything.

02
Round
Easy
Video Call
Duration30 minutes
Interview date14 Sep 2020
Coding problem2

1. Search in a row wise and column wise sorted matrix

Moderate
15m average time
80% success
0/80
Asked in companies
AdobeZomatoOracle

You are given an 'N * N' matrix of integers where each row and each column is sorted in increasing order. You are given a target integer 'X'.


Find the position of 'X' in the matrix. If it exists then return the pair {i, j} where 'i' represents the row and 'j' represents the column of the array, otherwise return {-1,-1}


For example:
If the given matrix is:
[ [1, 2, 5],
  [3, 4, 9],
  [6, 7, 10]] 
We have to find the position of 4. We will return {1,1} since A[1][1] = 4.
Try solving now

2. Valid Parenthesis

Easy
10m average time
80% success
0/40
Asked in companies
Expedia GroupInfosysSamsung

You're given a string 'S' consisting of "{", "}", "(", ")", "[" and "]" .


Return true if the given string 'S' is balanced, else return false.


For example:
'S' = "{}()".

There is always an opening brace before a closing brace i.e. '{' before '}', '(' before ').
So the 'S' is Balanced.
Try solving now
03
Round
Easy
Video Call
Duration30 minutes
Interview date14 Sep 2020
Coding problem3

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

Moderate
10m average time
85% success
0/80
Asked in companies
OraclePhone PeSAP 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.
Try solving now

2. Inplace rotate matrix 90 degree

Easy
12m average time
80% success
0/40
Asked in companies
OracleAppleGoogle

You are given a square matrix of non-negative integers of size 'N x N'. Your task is to rotate that array by 90 degrees in an anti-clockwise direction without using any extra space.

For example:

For given 2D array :

    [    [ 1,  2,  3 ],
         [ 4,  5,  6 ],
         [ 7,  8,  9 ]  ]

After 90 degree rotation in anti clockwise direction, it will become:

    [   [ 3,  6,  9 ],
        [ 2,  5,  8 ],
        [ 1,  4,  7 ]   ]
Try solving now

3. SQL Queries

SQL query - Top 2 users in a table - do it using subquery, views, and joins.
SQL query - Nested query using joins.

04
Round
Medium
HR Round
Duration50 minutes
Interview date14 Oct 2020
Coding problem0

The interviewer was very serious and was testing patience during the entire duration. He asked all W's for everything written in my resume and the round's difficulty was medium.

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

Which is a DDL command in SQL?

Choose another skill to practice
Start a Discussion
Similar interview experiences
company logo
SDE - 1
3 rounds | 2 problems
Interviewed by Oracle
6366 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
1834 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 5 problems
Interviewed by Oracle
977 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
SDE - 1
5 rounds | 12 problems
Interviewed by Amazon
104483 views
24 comments
0 upvotes
company logo
SDE - 1
4 rounds | 5 problems
Interviewed by Microsoft
49656 views
5 comments
0 upvotes
company logo
SDE - 1
3 rounds | 7 problems
Interviewed by Amazon
30954 views
6 comments
0 upvotes