Infosys Softeware Developer interview questions

It was a very technical interview and they check every aspect mentioned in the resume. They check each and every basic point for the mentioned technologies. Also, they look for how creative and present-minded you are with you on spot problem solving skill. They started with all the basic questions in Java, like OOPS, static vs final and then they moved towards Hibernate and from there they moved to all other technologies mentioned in resume. Then again the started giving multiple scenario based question and asked me to write the SQL queries foe the desired output.