[ OK ] f1IaY5SLnD — full writeup
[ INFO ] category: Behavioral · Onsite difficulty: difficult freq: first seen: 2023-08-26
[DIFFICULT][ONSITE]OnsiteSWE I (Entry Level)Unknown
$ cat problem.md
My friend interviewed for a Software Engineer position at Oracle GBU in . The interview process consisted of four rounds.
Round 1 (Technical)
- Self Introduction
- Preferred Coding Languages (Asked priority of C++, Java, Python)
- Basic functions that exist in Python NumPy like function for Standard Deviation and Mean
- Implement Binary Search in Python
- Installation Procedure of Oracle
- Version of Oracle used in College
- Basic questions about Clubs and memberships
- Introduction to Projects
- K-Means Clustering
- Why does "Are You A CAPTCHA" pop-up and how does it validate
- Heap and Stack Memory
- Real Time OS
- Single vs Multi Processor Devices
- Process Synchronization
- Semaphores
- DDL, DML, TCL, DCL commands and examples
- Merge vs Hash Join
- Types of Joins and Purpose of Join
- Types of Keys, Foreign Key in Detail
- Explain basic Normalisation
- SQL: Write a Program to find all Employees whose names start with 'S'
- SQL: Write a Program to Count number of Employees whose DOB lies between X and Y dates
- SQL: Write a Program to Validate a given string and return if it is a Valid Email Address or Not
- Email Validation in C++ since I couldn't do it in SQL
- Coding: Count number of Leaf Nodes in a Binary Tree
- Examples of Greedy, Dynamic Programming, 2 Pointers and Divide and Conquer
- Complexities of the examples given
- Explain Dijkstra's and difference to Floyd Warshall and Why is Dijkstra's Algorithm a Greedy Algorithm
Round 2 (Technical)
- Self Introduction
- Basic questions from Resume
- Projects in depth along with cross questioning
- Why is Python the current most preferred Language
- What is Testing, Testing Life Cycle
- SDLC Phases
- Positive vs Negative Testing
- Example for Negative Testing in MS Paint
- Manual vs Automated Testing, when is each of it implemented
- Will AI take over Testing? Explain your reasoning
- White Box and Black Box testing, when is each of it implemented
- If you test a code and it works on Day1 but the same fails on Day2 what could be the reason for this change assuming that the Code isn't Modified.
- What Issues did you face while testing your projects?
- Explain why you are an optimistic person (mentioned in Self Intro but was asked at the end)
- Version of Oracle used during Labs
Round 3 (Mostly Non Technical but not HR)
- Self Introduction
- Why Oracle? What made you choose GBU over Netsuite
- Hobbies
- Friends and Classmates, followed by discussion on why
- Favorite Subject
- Who all are in your Family?
- Where is Statistics used in Real Life (Follow up to my favorite subject being Statistics Driven)
- What is Hypothesis
- A Situation where you have been Heart Broken but how did you comeback?
- Basic General Discussions (Completely based on my previous Answer)
- Basic introduction to Projects
Round 4 (HR Round)
- Plans on Further Studies
- Willing to Relocate
- Hobbies
- What do you do when you are stressed
- Do you help your Parents in Daily Chores
- CGPA
The candidate was waitlisted. The offer was INR 19.18 LPA.