1.Deep dive into one of my projects, and follow-ups were asked. This varied from details being stored in the database,purpose,scope and feasibility of the application and main focus was on the coding aspect of it, like what coding was done.
2.Different types of joins and a SQL query using joins
3. 2-3 basic aptitude questions
Some people were also asked basic DSA questions like reverse string, swap two numbers without third one, so be prepared for such questions as well. Also ensure you know your resume inside out. Keep it simple as much as you can as the role being Associate Consultant, your achievements don't matter much so even if you have a simple resume, be confident in your communication and thorough with your resume as many people did get selected who had a simple and plain resume.