Oracle Interview Experience by Nandita Hans

New update is available. Click here to update.

MTS 1

Oracle

4 rounds | 14 Coding problems

Nandita Hans

Fresher | Oct 2020

Selected

1571 views

0 comments

10 upvotes

Interview preparation journey

Journey

I started my coding journey from the second year of graduation. I asked and consulted seniors on how to start in my career. I started doing DSA. In starting it was not regular but from the seventh semester, I started practicing DSA on regular basis. Meanwhile I also learned Web Development in the last phase of third year. Than, I was ready to apply in different companies.

Application story

I got a message in my telegram group about the company visiting our campus for the hiring of MTS-1. As, I was in the fourth year, it was sure that I am going to apply for it. I started preparing accordingly and got selected at last.

Why selected/rejected for the role?

I was confident during the full interview process. Actually, I worked a lot on my communications skills and I think they were the main reasons for me getting par the selection process.

Preparation

Duration: 2.5 months

Topics: Data Structures: Trees, Linked List, Stack and Queue. OOPS: Inheritance, Polymorphism. Java: Collection and Streams. Operating System: Threads, Process Management, Memory Management , Database management system: Joins, Normalization and Transactions (ACID Properties)SOLID Principles

Tip

Tip 1 : Make your basics strong don't run after new technologies as a fresher companies wants your good command on DSA
Tip 2 : Focus more on competitive programming to get into a good organization don't indulge to much in development because the first step to reach to the interview round is to clear the coding round
Tip 3 : Do at least 2-3 Questions per day and practice daily
Tip 4 : Also practice basic aptitude questions

Application process

Where: Campus

Eligibility: 7/10 CGPA and above,No Active Backlogs in any semester

Resume tip

Tip 1 : Don't mention things in the resume that you don't have full command on you should have complete knowledge of what you mention in your resume
Tip 2 : Make your resume short and if you mention projects in your resume be clear about the details of the project even if you have done that in group because the interviewer will surely ask from it.

Interview rounds

Round

Medium

Online Coding Interview

Duration107 minutes

Interview date1 Oct 2020

Problems2

Data Structures

How to find the pre order traversal of a tree?
State complexity of merge sort
Questions based on radix sort

Problem approach

Tip 1 : Practice preorder, postorder and inorder traversal questions of a tree
Tip 2 : Understand merge sort
Tip 3 : Have complete understanding of Radix sort

Preorder traversal to BST

You have been given an array/list 'PREORDER' representing the preorder traversal of a BST with 'N' nodes. All the elements in the given array have distinct values.

Try solving now

Round

Medium

Video Call

Duration30 minutes

Interview date5 Oct 2020

Problems6

Check if number is Binary

Given a string of integers ‘bin’. Return 'true' if the string represents a valid binary number, else return 'false'. A binary number is a number that has only 0 or 1 in it.

Input Forma...

Problem approach

Step 1 : First I converted the number into string and checked if each character is 0 or 1
Step 2 : The interviewer asked me if there is any other approach to solve this problem
Step 3 : I picked the approach of picking up the digit of integer from last and then checking whether that it is 0 or 1

Step 4 : If we get a digit other than 0/1 we will break the loop. The interviewer was ha...

Try solving now

Rearrange The Array

You are given an array/list 'NUM' of integers. You are supposed to rearrange the elements of the given 'NUM' so that after rearranging t...

Problem approach

Tip 1 : I looked through the array and used a map to count frequency of each digit

Try solving now

Number and Digits

You are given a positive number ‘N.’ You need to find all the numbers such that the sum of digits of those numbers to the number itself is equal to ‘N.’

For example:

Problem approach

Step 1 : We can sort the array by sort() function but this would have a complexity of O(nlogn)
Step 2 : Interviewer told me to go for another approach that would have complexity lesser than this
Step 3 : I took first and last pointer in the array that will point to the start and end of the array respectively. We will swap first with last. If we find 0 in the last and 1 in the first we wil...

Try solving now

Reverse a string

You are given a string 'STR'. The string contains [a-z] [A-Z] [0-9] [special characters]. You have to find the reverse of the string.

For example:

Problem approach

Step 1 : I converted string into a character array
Step 2 : I took first and last pointer in the array that will point to the start and end of the array respectively. I swapped first with last and continued to increment the first and decrement the last pointer until I reached the mid of the array and this approach has complexity O(n)

Try solving now

Puzzle

You have 10 coins one of them is defective. You have a weight scale. How will you identify the defective coin?

Problem approach

Tip 1 : I started explaining to him we have 3 coins and each correct coin weighs 1gram and defective coin weighs 0.5 gram
Tip 2 : First I will put coin 1 and 2 on the weight scale and weigh them and if I get weight as 1.5gram it means one of them is defeated so I will again weight the left over coin with each coin and by this approach we will get the defective coin
Tip 3 : The interviewer...

Operating System

What will be the result when we will add two binary numbers in 64Bit and 32 Bit operating system?

Problem approach

Tip 1 : Read concepts of 64Bit and 32Bit Operating System properly

Round

Medium

Video Call

Duration30 minutes

Interview date5 Oct 2020

Problems2

Rewrite code

There were 5 statements code snippets in python. I was told to write that in Java.

Problem approach

Firstly I tried to understand the code snippets because I have no knowledge of python. I asked the interviewer to please specify the input and output of these snippets so that I can easily code them in Java. There were 5 problems. I was able to solve each of them. There was a question of dictionary in python so relatively I used map in Java to solve that question.

Situation based questions

Have you ever faced criticism in life and how have you to tried to overcome it?
Have you ever done anything by stepping out of your comfort zone?

Problem approach

Tip 1 : Try to relate with real life stories that you have.
Tip 2 : Always stick to the topic or question

Round

Easy

HR Round

Duration30 minutes

Interview date5 Oct 2020

Problems4

Tell me something about yourself?

Problem approach

Tip 1 : Prepare the points that you will speak in your introduction prior to the interview.
Tip 2 : Tell about your current cgpa, achievements and authenticated certification
Tip 3 : I told about my role in current internship and what all I do

Work Experience

What all you did in internships? What all technologies you have worked on? What is your project in internship?

Problem approach

Tip 1 :Mention the framework, Frontend, Backend ,Database in technologies
Tip 2 : Be clear with the project of internship if you are mentioning in the resume

Why you want to be a part of Oracle?

Problem approach

Point 1 : It's the dream company of almost every fresher
Point 2 : 3rd most leading firm in software industry

What all you except from an organization that you work?

Problem approach

Point 1 : Learn new things each day and keep growing an as individual