Round 1:(MCQ Round)
MCQ questions from topics like DSA, CN, DBMS, OS
159 were shortlisted for the next round

Round 2:(Coding Round)
1 coding question was given for 60mins
27 were shorlisted after this round

(Interview) Technical Round 1:
1)Started with the resume and as I had mentioned SQL, he started asking questions on that
2)2 SQL Queries based on creating a table with a primary key and a foreign key.
3)SQL joins: explain what is it and the different types of joins and explain each.
4)What is union in SQL? What happens if we use it? Is it the same as join?
5)Difference between drop and truncate?
6)How to Find the employee name with the lowest and highest salary?
7)If I made a column with a certain data type but I want to change it, how will I do it?

Then he moved on to OOPS and questions on JAVA
1)What is OOPS?
2)Explain encapsulation, polymorphism, abstraction and inheritance?
3)What is the use of "new" keyword.
4)What is a class? What is an object?
5)Why java is platform independent

Then he started asking questions on html as I had mentioned it in my resume
1)What is block and inline elements?
2)How to create a hyperlink?
3)what are the tags in html?
4)what is the use of alt in tag?
5)what are semantics?

Then he started asking about my projects
1)Write a program to find if there is a vowel present in a string
The interview lasted for 40 mins

10 were shortlisted in this round

Technical Round 2:
1)What are singly linked lists?
2)Explain the difference between singly linked list and arrays?
3)Delete A Node With Only Pointer Given To It?
4)Find the minimum in a sorted rotated array(Leetcode Medium)
5)Write a Query to find all the employee names with the 3rd highest salary

lasted for 30mins
6 were selected for Intern+Full time