Media.net Associate Database Developer interview questions

It was a walk-in I went for, 0-2 years experience people. With I am having nearly 1.7 years experience in database. 1st round Apti : Questions will based on database, logical q and data structure. 2nd Round Technical interview : Nearly 1 and half hour of interview for me. Will tell you to write queries for particular output to display. Most probably queries based on joins. Some theory questions and questions on Data structures like searching, sorting algo. They expect atleast algo you should write if not code. 10 min break 3rd Round Technical interview : Again 1 and half hour interview for me and same whatever they asked in 2nd round. Add on will be some puzzle and will ask You to optimise the query. 4th Round Technical Interview : 1 hour interview for me. And difficulty level might be lil bit high as compare to other 2 rounds. But will ask you to write queries and some theory q.