My friends interview NOT MINE

Round-1(Technical)

Self Intro
Preferred Coding Languages(Asked priority of CPP, 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 Our College
Basic questions of 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 CPP 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 Intro
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 Intro
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

Result: Waitlisted 19.18 lpa