Round 1: Coding round which had 10 MCQs based on JAVA and MYSQL along with 4 coding questions. The total duration was 75 mins (15 + 60).
- Print strings starting with the given prefix.
- Print all leaf nodes of a tree.
The other 2 questions were lengthy, I do not remember the question. I was able to successfully submit 3/4.
- Print the right view of a tree and dry run it.
- Hashmap and it’s working
- Difference between ArrayList and linked list.
- Questions on the design pattern. I told the interviewer that I have experience in using factory design and singleton. He started asking questions on singleton pattern like where to use it? What are its advantages? How to make sure that only one instance is created?
- Questions on indexing in MySQL.
- How annotations work in jersey framework? Jersey was asked since I mentioned it in my resume.
- A person has to climb n stairs but at a time he can only climb either 1 stair or 2 stairs. In how many ways he can reach nth stair? This is a simple Fibonacci series-based question.
- Questions based on jersey framework. How annotations internally work, which I didn’t knew that time.
- Questions based on table indexing and db partitioning.
- Write a code to make a custom class as key for a java hashmap. What needs to be taken care in this case? Questions were tricky. The class he gave me had a list variable too and I did not knew the time that we have to make it immutable too.
Round 4: The worst round
The interviewer had very poor English. He was unable to explain the question and even questions were not to the level of 2.5 years experience.
- Suppose you have a customer base of 1 billion, how will you calculate the number of requests to process? How will you limit the number of requests?
- How to make a method as REST?
- What will happen if we write poor hashcode?
- Questions on string pool.
- He gave me a query to write department name, along with number of females and males. I did that using CASE for which he argued that Mysql does not have CASE functionality. Hello Mr Interviewer please look this https://www.w3schools.com/sql/func_mysql_case.asp . Anyway, I modified it using IF ELSE which he approved.
- How to create a clustered index in MySQL?
- How to increase data type length of a primary key. Write command.
- NIO and BIO in java
Apart from 1st 2nd and 8th I answered all and yet the result was negative.
Anyways, guys do post answer of 1, 2 and 8th in comments.
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready. To complete your preparation from learning a language to DS Algo and many more, please refer Complete Interview Preparation Course. In case you are prepared, test your skills using TCS, Wipro, Amazon and Microsoft Test Serieses.