First round: General aptitude questions and some puzzles. You're expected to give proper solutions. Now, one piece of advice: Think out loud. That way even if you aren't able to arrive at an answer they get to know your line of thought. That way they might correct you or say things like 'what if...' that way you can think of another possible solution. This might not fetch you the same points as someone who's giving the right answer but the thing is, for an interviewer, this is better than getting a blank stare. Second round: C/C++ questions and I was asked one data structures question which I was expected to code(write the actual code and not just a snippet). I think they'd asked how to find the loop in a doubly linked list(not sure). They look for boundary conditions and expect you to give a neat working code. Third round: I was asked one logic question which I was asked to code the solution for in any language(again full code, not just the algorithm). I don't remember if they'd asked me any SQL questions in this round. Even if they had, it would have been a few simple queries only. Fourth round: Final round was a courtesy sake HR round. You're pretty much done if you've reached this round. Just don't say anything as stupid as you're planning on doing an MS or something.

3 rounds. Round 1-dsa, sql, overall system architecture for similar system to makemyshow, sorting algos. Round-2 dsa, database designing. Round-3 all questions purely on resume. Plus, one small hr round