10 Aptitude Questions
10 English Verbal Reasoning Questions
1 Coding Question: Lexicographically Largest Subsequence
1 Rest API Question - Maximum Transfer Similar to Hackkerank api questions
This round was easy and straightforward.
Interviews
Technical Round 1 (40 mins)
The interviewer asked me to explain GitHub and its commands.
Explain the different types of Version Control Systems (VCS).
List and explain all the Git commands.
What should be done when merge conflicts occur in GitHub?
A question regarding HTML/CSS: Given three overlapping boxes, on moving the mouse pointer over one box, that particular box should come above, and on moving out, it should go back to the original place.
One Data Structures and Algorithms (DSA) question was asked: Trapping Rain Water (from LeetCode)
Explain different sorting techniques. The interviewer asked me to explain Heap sort by writing the code and doing a detailed dry run on it.
Discuss different ways to store a Tree.
I asked two questions at the end of the interview.
Technical Round 2 (70 mins)
The interviewer reviewed my resume and asked me to explain each of my projects.
Questions about Machine Learning/Data Science concepts were asked in detail related to my projects, including dataset based SQL questions.
Questions about terms like Precision, Recall, MSE, CNN, KNN, and Clustering, along with real-world examples.
Was asked to List the electives I have taken and was asked questions related to them (in my case, Data Mining and Cryptography)
Asked about my plans for higher studies.
Inquired about why I hadn't completed any internships so far.
Asked me to explain different possible time complexities, how they are calculated, and provided scenarios where different time complexities occur.
Was Presented with two SQL queries:
-> One using Joins
-> One using 3 nested subqueries
Interviewer asked me about my adaptability skills and requested a real-life situation showing it.
I asked three questions at the end of the interview.
Technical Round 3 (45 mins)
An introduction about me, both technically and non-technically, was requested.
Explain the different DDL, DML, and DQL commands.
Solved a DSA question, a Variation of Find the Index of the First Occurrence in a String (from LeetCode)
Discussed Normalization and its purpose.
Detailed explanation of 2NF and BCNF was asked.
Was asked to explain all 7 OSI Layers along with associated protocols.
Explained Multithreading in Java, including codes for Thread and Runnable Interface.
Discussed Deadlocks and how to detect them.
What are Semaphores.
Explain Triggers and PL/SQL
I asked one question at the end.
This was a HR round for the majority of the people, but they kept a Technical Round for me.