The entire process, from the date I got a call till I joined, took 4 months.

There were:

• 2 Tech Rounds: spent 1/2 day.
• 1 HR Round: telephony the next day.

Scenario-based solutions:

• Performance tuning.
• Basic questions, like which index you would create in which scenario and why.

Explain and counter-questions, such as what will happen if we create an X type of index instead of a Y type.