The interviewer will test all basic and intermediate component related questions and after this it ask to make query as fast as possible and then they will try to confuse you in joins or keys. There can be 3 round of Technical interview.