Oracle Interview Experience by Anuj Singh | MTS | Full TIme | Virtual On Campus 2020

 



ORACLE INTERVIEW FULL TIME

Oracle visited our campus for virtual hiring for two roles

1-Server Technology

2-Application Development

Around 500 students appeared for the online test.

There was a single online test for both the roles and students were shortlisted for the

above roles depending on their performance in the test.

ONLINE TEST (107 Minutes)

Online test was conducted on their own platform and it was fully proctored i.e. webcam

& mic was enabled.

Test consisted of 4 sections Technical, Programming, Aptitude and Contextual

Communication.

Each section was divided into different subsections with fixed allotted time.

All the questions were objective with no negative marking.

Technical:- ​ This section was basically to test your knowledge about computer science

subjects like OS,DBMS,OOD,Software Engineering,Data Structures and there were

some questions related to time complexity and Big O notation

Programming:​ - The section was full of questions related to tree traversal, Binary

Search Tree, AVL Tree with use of Abstract Data Type

Aptitude:- ​ It was having five subsections ​ Math reasoning, Data analysis and critical

thinking, Persistence, Programming and ability(Program flow), Logical ability

Contextual Communication:- ​ Grammatical usage, Learnability, Written expression,

Reading Comprehension

Around 45 students were shortlisted for Server Technology role and 30 students were

shortlisted for Application developer role.

I was shortlisted for Server Technology :)

All the interview rounds were conducted on zoom platform and a virtual interview

Environment was created on zoom.INTERVIEW ROUND 1(Around 45 Minutes)

● Firstly the interviewer introduced himself and gave a brief idea about his role in

organisation and then he asked about me. It was kind of formal introduction

from both the sides.

● Then I was asked two coding questions and I was supposed to write running

code for it on the coderpad platform.

Given an unsorted array ​ arr[]​ of size ​ N ​ , rotate it by ​ D ​ elements (clockwise).

https://practice.geeksforgeeks.org/problems/rotate-array-by-n-elements/0

I​ g

ave him three different approaches for it and finally he said to write code for

the best optimal approach in terms of time and space complexity.

Merge two sorted linked lists.

https://www.geeksforgeeks.org/merge-two-sorted-linked-lists/

I directly gave him the recursive approach and completed the code for it.

Then I asked him a question

What are the major challenges a fresher has to face after joining corporate?

INTERVIEW ROUND 2(Around 70 Minutes)

● I ​ nterview started with formal introduction

● Then he asked me to explain about a project from my resume that was related to

finding currency arbitrage opportunities in Foreign Exchange Market. Since I used

Bellman Ford's Algorithm to implement it so he asked about the Algorithm.

● Then he moved on to my second project and asked to explain it and then he

asked some questions about Socket Programming and Multithreading.

● I was asked a coding question

A string is given and we have to check whether it is the correct format of ip and

and if it is correct then is it private ip or public ip?

I was supposed to take care of every possible corner cases and test cases were

like

A.B.C.D

172.31.100.25

a3d.b4c.125.100

172:100.31.25

256.100.54.124

172.31.100

192.168.100.25

0.0.0.0●

192.100.25.36.12

172 31 100 25

17231.100.25

I wrote complete running code for this keeping in mind users can give any input.

What is a subnet mask?

He asked about public and private network and detail about TCP socket

Then he moved on OOPs questions

What is OOP?

What is polymorphism?

What is Encapsulation?

Static and Dynamic Binding?

Then he asked about abstract class and asked to give an example for abstract

class and write code for it in java.

INTERVIEW ROUND 3(Around 45 Minutes)

● Started with a formal introduction and then the interviewer asked about my

previous rounds just to make me comfortable as I was a little tired sitting for

about 4 hours .

● Then he asked what are different subject you have studied in previous semesters

and in which subject (except OS,DS,Algo,DBMS) you are more comfortable.

In response to it I said Cryptography as I was little comfortable in it.

● He asked about different network attacks in brief.

● Then we had a detailed discussion on symmetric and asymmetric cryptographic

algorithms and their computation cost and vulnerability.

● Then he asked about Virtual Private Networks.

● He asked me to design VPN. For a moment I was blank faced then he said I am

not looking for the correct solution as you don’t know the protocols so u can’t

design it but I am looking for your approach then I gave him different approaches

and meanwhile he was helping me to design it and he seemed to be satisfied.

● Then he asked me to explain my mini project (Nowhere I mentioned the term mini

project(6th sem Academic project) in my resume but previously he interviewed

some other candidate and knew about it). It was related to load balancer so he

asked some questions on load balancer.

● What is virtualisation?

● In continuation to the previous question he asked about virtual machines and

what is the role of virtual machines and how resources are managed between

different OS.

● Then we had a brief discussion on Hypervisor and types of hypervisor.Then he asked about unix system calls.

He asked the reason behind my low CPI (Although I have CPI greater than 8.5)

How do you learn things?

Why do you want to join oracle?

Do u have any questions? I asked a couple of questions.

Then we had a discussion on how work is going on in COVID situation and he

told me about the perks of joining Oracle and had a detailed discussion on

different teams in oracle.

● He was sharing his experience of college and corporate and about the work

culture and also had a discussion on the benefits of having good people in your

network.


INTERVIEW ROUND 4(Around 10 Minutes)

It was HR round and he asked a couple of questions

● How were your previous rounds?

● Do you think you will get selected?

● Are you comfortable with job locations?

● Tell the name of five products of oracle?

● What is probability?

● What is the probability of getting a job offer if 50 students are shortlisted for an

interview?

And this is how all the four rounds were concluded and I got selected for the Server

Technology role.


Anuj Singh

CSE2k21


TIPS

● Be confident and eager while appearing for an interview and don’t mug up the

things just before the interview.

● Try to show enthusiasm during the interview and discuss all the thoughts with

the interviewer.

● Do not fake in Resume. Be thorough with what you know and what you write in

your resume.

● If you don’t know about any topic, tell the interviewer clearly about it.

Comments