AdventSys Technologies interview questions

Two Rounds 1) 10 MCQ and two short programs to execute a) Program on design Pattern b) Ms- Sql joins c) Web API 2) Manager Round a) Gave a task of web API 3) HR Round

It was good and the questions was tough .Asked questions were on programming and DB. First round was Aptitude. After that the second round was programming interview where questions was related to DB sQl Java. Expecting great level of prior knowledge.