[ INFO ]category: Behavioral · Onsite difficulty: difficult freq: first seen: 2023-08-26
[DIFFICULT][ONSITE]OnsiteSWE I (Entry Level)Accepted
$catproblem.md
My friend interviewed at Oracle for a Software Engineer position. The interview process consisted of four rounds.
Round 1 (Technical)
The interviewer asked about my friend's Computer Science Business Studies (CSBS) background and the need for CSBS.
They discussed the business subjects my friend had taken and what they learned from each.
My friend was asked to write a string reversal program with code and they provided three approaches, coding the most optimal one.
The interviewer discussed my friend's projects, including the need for the project, why they chose it, and the technologies used.
They asked questions about MongoDB, including syntaxes, advantages, database schema, and class diagrams.
The interviewer asked questions about operating systems, including the bootstrap program, threads, processes vs. programs, scheduling algorithms, and the Round Robin problem.
They also asked about database management systems (DBMS), including normal forms, ACID properties, serializability, SQL vs. NoSQL differences, and a simple SQL query on inner join.
The interviewer asked about computer networking (CN), including the OSI model, layers, data changes between layers, TCP vs. UDP differences, real-life examples of TCP and UDP, and FTP protocol.
Round 2 (Technical)
The interviewer asked my friend for a self-introduction and basic questions from their resume.
This round focused on my friend's internship experience, with a detailed discussion.
They walked through the project's user interface and discussed what could have been done better.
The interviewer asked my friend to write code for the Fibonacci series.
They asked about troubleshooting scenarios, such as a code working yesterday but not today.
The interviewer asked about Git commands, the importance of branches, merge conflicts, and how to resolve them.
They asked questions related to my friend's open-source contributions.
The interviewer asked about object-oriented programming (OOP) concepts, including overloading vs. overriding, inheritance, and the diamond problem.
They also asked some basic DBMS questions.
Round 3 (Mostly Non-Technical)
The interviewer asked my friend for a self-introduction and to explain their projects and internship work in detail.
They asked about my friend's open-source contributions and if they had read the job description and what they understood from it.
The interviewer asked why my friend was interested in Oracle and where they saw themselves in the next three years.
They asked my friend to choose between a team of great developers or a team of average developers.
The interviewer discussed my friend's volunteering experience and the biggest problem they faced during hackathons they organized.
They asked how my friend managed their time for projects, academics, and volunteering experiences.
The interviewer asked about my friend's plans for higher studies and why they didn't want to pursue a master's degree.
Round 4 (HR Round)
The interviewer asked about my friend's plans for further studies, willingness to relocate, hobbies, how they celebrate a friend's success, and their GPA.
My friend received an offer with a compensation of 19.18 LPA.