In the technical round, the questions varied depending on the situation. The interview typically started with either pattern-based questions or OOP (Object-Oriented Programming) concepts; in my case, it began with pattern-related questions, while one of my colleagues was asked about OOP concepts. This was followed by several key topics: 1) join queries and normalization to assess SQL fundamentals, 2) update queries to understand data modification techniques, 3) stored procedures, as the company frequently works with them, and 4) delete queries, focusing on the differences between TRUNCATE and DROP to gauge an understanding of data deletion methods and their implications.
In the HR round, the questions were more personal and behavioral. They asked me to 1) introduce myself, 2) talk about my family, 3) describe my city, 4) mention what my city is famous for, and 5) assess my ability to handle pressure, especially considering the two-year bond requirement, to understand how well I could manage stress and long-term commitments.