Oracle Interview experience|2023 | Associate software Engineer | 19.18 LPA | Pihu | Aim2Crack

Summary

The speaker shares their interview experience with Oracle, detailing the selection process that included an online assessment with tutorials, CPA, and coding questions, followed by interviews focusing on OOPs concepts, DBMS, and project-related inquiries. The interviewees were engaged with informative presentations and interactive sessions, leading to multiple rounds of technical and HR interviews. The candidate's preparation, including Striver's sheet and project explanation, played a crucial role in their successful selection.

Takeaways

• 📝 The candidate had a CTC of 19.1 LP with a base salary of 14.5 LP for the Oracle interview process.
• 📑 The initial step involved submitting a resume through a Google form followed by an online assessment.
• ✍️ The online assessment included 22 tutorial questions, a coding problem, and a CPA question, with a medium difficulty level.
• 🗣️ There were 65 people shortlisted for interviews after the assessment, with the candidate being one of 27 in the communication unit.
• 🕒 The interview process started with an informative PPT session, which was crucial for understanding the company and preparing for the interview.
• 🤝 The interview involved interaction with the interviewers, who asked both technical and project-related questions.
• 🔄 The candidate faced questions on OOPs concepts, DBMS, and had to demonstrate coding skills for linked list problems.
• 📈 The interview also covered OS, normalization, and deep dive into the candidate's project, emphasizing the importance of preparation.
• 📚 The candidate found Striver's sheet helpful for preparation, especially for DBMS, OS, and OOPs topics.
• 🤔 The second interview focused on additional technical topics and personal interests not mentioned in the resume.
• 🏆 The final HR round was shorter and more conversational, discussing family background and favorite subjects, before the candidate was selected.

Q & A

What was the CTC and base salary offered by Oracle in this interview experience?

The candidate was offered a CTC (Cost to Company) of 19.1 LP (Lakhs per annum) and a base salary of 14.5 LP.

What was the first step in the Oracle interview process described in the script?

The first step was submitting the resume through a Google form.

How many tutorial questions were there in the online assessment test?

There were 22 tutorial questions in the online assessment test.

What type of questions were included in the online assessment test?

The online assessment test included CPA (Case Partnering Ability) questions, coding questions, and 20 verbal ability and aptitude questions.

How many people were shortlisted for the interviews after the online assessment test?

Around 65 people were shortlisted for the interviews.

What was the significance of attending the PPT session before the interviews?

The PPT session was informative and engaging, providing insights about the company which helped the candidate during the interview.

What was the duration of the first interview round?

The first interview round lasted for approximately 50 to 55 minutes.

What programming concepts were discussed during the first interview?

The first interview covered Object-Oriented Programming (OOPs) concepts such as polymorphism, virtual functions, and also included questions on DBMS and the candidate's project.

What was the nature of the coding question asked during the first interview?

The coding question was about finding the intersection of linked lists, with the candidate providing both an optimal approach and an alternative method.

What was the focus of the second interview round?

The second interview focused on OOPs, OS, normalization, and DBMS, with questions related to threads, processes, and binary search trees.

What was the duration of the HR round compared to the technical rounds?

The HR round was shorter, lasting around 35 to 40 minutes, compared to the 50 to 55 minutes of the technical rounds.

What type of questions were asked during the HR round?

During the HR round, questions were asked about the candidate's well-being, family background, and some technical questions related to APIs and the candidate's favorite subject.

How long did it take to receive the interview results after the final round?

The results were declared about an hour after the final HR round.

What was the candidate's strategy for answering questions about their project?

The candidate prepared to explain their project in detail and kept their explanation ready beforehand to answer any questions about it.

Outlines

00:00

📝 Oracle Interview Experience and Process

The speaker shares their interview experience with Oracle, detailing the recruitment process which began with submitting a resume through a Google form. This was followed by an online assessment consisting of 22 tutorial questions, a coding problem, and 20 questions on verbal ability and aptitude. Around 65 candidates were shortlisted for interviews, which were divided into two units: food and beverages, and communication. The speaker was part of the latter with 27 other candidates. The interview process included an informative PPT session, which the speaker highly recommends paying attention to, as it was beneficial during the interview. The interview itself involved questions on Object-Oriented Programming (OOPs), Database Management Systems (DBMS), and the candidate's project mentioned in their resume. The speaker also faced a coding question related to linked lists and emphasized the importance of being prepared to explain their approach and code. The interview concluded with the candidate asking prepared questions to show interest in the company.

05:00

🔍 In-Depth Oracle Interview Insights

The second paragraph delves deeper into the interview experience, focusing on the second round where the candidate was asked to share additional information not mentioned in their resume. The interview covered topics such as Operating Systems (OS), normalization in databases, and Object-Oriented Programming (OOPs). The candidate found the Striver's sheet particularly helpful for preparation. Questions on Dynamic Programming (DP), linked lists with random pointers, and binary search trees were also part of the technical discussion. The candidate was also asked about their project in detail and had to explain the concepts and implementation. The HR round was shorter and more personal, with questions about family background and the candidate's interests. The HR also discussed the candidate's favorite subject, smart grids, which aligned with the company's requirements. The interview concluded with a discussion-based round, and the candidate was selected after the results were declared an hour later.

Keywords

💡Oracle

Oracle is a multinational computer technology corporation known for its database software and technology, cloud-engineered systems, and enterprise software products. In the context of the video, it is the company for which the interviewee is seeking employment. The script mentions 'Oracle my CTC is 19.1 LP,' indicating the compensation package being discussed for the position.

💡CTC

CTC stands for 'Cost to Company,' which is a term used in the context of employment to refer to the total cost incurred by the company for an employee, including salary, bonuses, and other benefits. The script mentions 'my CTC is 19.1 LP,' which denotes the total compensation package being offered by Oracle.

💡LP

LP likely stands for 'Lakhs per annum,' a unit used in India to denote a salary package in terms of 100,000 units of currency per year. It is used in the script to quantify the interviewee's compensation package: '19.1 LP' refers to nineteen lakhs and ten thousand per annum.

💡Online Assessment Test

An online assessment test is a digital examination conducted over the internet, often used by companies to evaluate candidates' skills and knowledge before interviews. The script describes such a test with '22 tutorial questions,' 'CPA question,' and 'coding question,' indicating the variety of skills assessed.

💡OOPS

OOPS stands for 'Object-Oriented Programming Systems,' a programming paradigm based on the concept of 'objects,' which can contain data and code. In the script, OOPS is a significant part of the technical interview, with questions on 'polymorphism,' 'virtual functions,' and other OOPS concepts.

💡DBMS

DBMS stands for 'Database Management System,' which is a software that interacts with end-users, applications, and the database itself to capture and analyze data. The interviewee was asked DBMS-related questions, such as 'languages of DPMS,' indicating the importance of database knowledge in the role.

💡PPT

PPT stands for 'PowerPoint presentation,' a widely used tool for creating visual presentations. In the script, the PPT session is described as 'very informative' and 'engaging,' highlighting its role in providing insights about the company and helping the interviewee prepare for the interview.

💡Interview Process

The interview process refers to the series of steps taken by a company to assess a candidate's suitability for a job. The script details this process, including attending a PPT session, technical interviews, and an HR round, showcasing the comprehensive evaluation method used by Oracle.

💡Coding Question

A coding question is a type of problem presented during a technical interview that requires the candidate to write or discuss code to solve a problem. In the script, the interviewee faced a coding question related to the 'intersection of linked lists,' demonstrating the practical programming skills assessed.

💡HR Round

The HR round, or Human Resources round, is the final stage of an interview process where the candidate's fit for the company culture and role is assessed. The script describes this round as involving questions about family background and personal interests, indicating its focus on the candidate's personal attributes.

💡Selected

To be 'selected' in the context of a job interview means to be chosen for the job after successfully passing all interview stages. The script concludes with the interviewee being 'selected,' signifying a successful outcome of the interview process.

Highlights

CTC of 19.1 LP and base salary of 14.5 LP

Resume submission through Google form

Online assessment with 22 tutorial questions and a rest CPA question

Coding question in the assessment was of medium difficulty

20 questions on verbal ability and aptitude

65 people shortlisted for interviews

Interview preparation with a PPT session

Engaging PPT by the company representative

Interviews started after a 10-minute break

Interview process included questions on OOPs, DBMS, and project details

Coding question on intersection of linked lists

Second interview focused on OS, normalization, and advanced DBMS topics

Interviewer asked for introduction not mentioned in the resume

Questions on threads, processes, and deep dive into DBMS

DP question on grids and different approaches to DP

Linked list question involving random pointers and deep copy

Binary search tree question and tree properties

HR round with questions on family background and technical knowledge

Discussion on favorite subject and its relevance to company requirements

Result declared one hour after the final interview

Transcripts

foreign

[Music]

I am here to share my interview

experience for Oracle my CTC is 19.1 LP

and base is 14.5 lb right so for the

process first of all I gave my resume

into the Google form and next there was

an online assessment test in which um

there were 22 tutorial questions around

two hours of tests and one was a rest

CPA question and one was coding question

which was like for everyone like there

were sets so it was pretty basic

probably a medium or hard not really

hard easier medium level of lead for

questions okay and then there were 20

verbal ability and aptitude questions

okay so like after that around the 65

people were shortlisted for the

interviews

um and that was told to us like around

one to two days before the interview

so um in that there were they had two

units one was the food and beverages

unit and one was the communication and

communication there were 27 people

around and I was one of them so um as

for the interview they were they asked

us to come for the PPT first and the PPT

was around 9 to 9 15 in the morning so

we went there and we attended the PPT

the PPT was very informative so make

sure whenever you're attending a

interview or something and they are

having a PPT do pay attention to it

because it really helped in my interview

later on

so uh yeah I like the PPT was very

engaging the person who was giving it

the sir it was very interesting and he

told us a lot about the company he was

very like interacting with the students

it was a fun session actually

like after that the head of that

department and all they told us that we

can have a break of 10 minutes and after

that interviews will start and as they

said after 10 minutes they had some

panels and like six people were there in

our unit who were going to take the

interviews two were women and

men

so like after that they started with the

interview process everyone was going

like into the room and giving the

interviews like mine came after a while

I guess around one

0.5 to 2 hours later I gave my interview

first interview so in that

um first of all that sir gave me his

interview and I asked a couple questions

from his uh from his introduction I'm

sorry introduction like it it made me

feel like I was interested in their

company like I really wasn't into him

too so um

after that I gave my introduction I gave

some spontaneous points as well like the

introduction that I prepared I added

some points I reduced some points

whatever I felt like came to my mind at

the moment that is fine like so it's not

you need to cram everything you know

like whatever comes to your mind just

saying it right then um I was sitting

right in front of them so he uh mostly

asked me questions of oops like basic

oops polymorphism its types and I have

to show the code how it's written like

virtual function and all that like oops

was the base of this interview then

there was a bit of dbms like the

languages of DPMS and um like couple

questions related to it if I have ever

worked on a database and all that was

all about it and then he also asked a

little bit about my project that I

mentioned in my resume like it was based

on a website so he asked me some API

questions and all that was all then he

gave me a coding question it was based

on linked list specifically it was

intersection of linked list first I gave

him the optimal approach and then he

asked me if he can if we can do it do it

in some other way then I gave him the

other one as well like I was supposed to

write the pseudo code and explain it to

him he gave me around two to three um

like examples to solve and uh dry run

right so that was all about the

interview at the end I asked him a

question that I had prepared and I had

integrated from the PPT that I listened

to so that it shows that I'm interested

in their company and listen to their

presentation and all it just puts an

impact like after then around 30 minutes

I was

told by the pr that I was going to have

a second interview like after 15 minutes

of him telling me that I went for the

second interview the second interviewer

was also a very nice man and um he

didn't actually give me asked me to give

his introduction

so he said that I should tell him

something that's not mentioned in my

resume anything that I do any

interesting thing so I did come up with

an answer spontaneously so do keep it

prepared as well like whatever is

mentioned in your resume is not just

some hard and fixed rule that you have

to know everything about that or not so

get some other things as well so um

after that

um after I've given my introduction and

all he asked me for

questions like related to OS a bit of os

and then there's normalization and all

that and um

yeah most was oops again in this

interview and a little bit of demium is

too like how database is managed and all

like some um deep dvms then according to

my project you also asked me some other

questions like what are threads what is

a process

and a couple questions related to that

so like as for that the dbms OS and CEO

part I believe that striver's sheet was

the best for me like I did it Monday

before and it really helped

okay so um he also asked me quoting

questions uh one was of DP like DP on

grids there were there was a grid and I

have to go from start to end point and

there are some like huddles so I have to

cross them and tell me tell him the

number of fields I was supposed to write

some code or um you know just not much

just I have to explain my Approach then

I have to then he asked me the other

ways of DP so I told him memorization

Revolution no yeah that's it so then he

asked me a linkless question again so it

was like it's on lead code uh it's a

random pointer on the linked list and I

have to deep copy it so I did it has

been lining the approach I told you and

he seemed convinced then he was also

asked me a binary search tree question

like

um if I have been given a tree I have to

tell if it is a BSG or not that was the

question also I was asked the what is a

pre-order post order in order and the

type of the difference between the trees

like what is a fully connected tree you

know

um like all that

um yeah that was really all about the

second interview and um he was also

asked me a lot a lot about my project

and how I did it I just had to explain

the project like keep your explanation

ready like beforehand

so that was all about it also

uh the interview was nice he asked me if

I could ask if I want to ask any

questions again that I have prepared the

questions I asked him about

then I was informed that I was going to

have a third interview like it took a

while like the it was the HR round so

around two to three hours later I was

called out for the round it was a short

round the earlier two were 50 to 55

minute rounds both and but this one was

around 35 to 40 minutes only so it was

um HRM the HR stood up and greeted Me by

hand and it was really far out of him

then he asked me some basic questions

how are you and all that and then he

asked me about my family background how

many people are there what do they do

what do they do and all that like just

basic family based questions right

so after that he asked me some CN

questions and database related questions

like he wanted to know the answers

related to apis and if and he wanted to

know if I had an idea of apis that's all

he wanted to know also I he asked about

my favorite subject since I have from

electrical I had to tell one of that and

I chose

um smart grid so it was related to the

word smart so we discussed a lot on that

uh because it was a almost like a

cloud-based thing so it matched with

their requirements so I told them all

about it like it was a basic run

actually and it was just a discussion

based round as I felt it and that was it

like after that from one hour later we

the result was declared we were all

asked to go in and go into the room and

the result was declared and I was

selected that was all about mind

experience

foreign