Questions posées lors d’un entretien d’embauche pour Software Engineer - Java Developer chez ETNIC

Technical test from a external assessor. It is rather hard because there are not much time for answering so be prepared with java syntax, refactoring with OOP, data structures and algorithms. There are questions with multiple choice and long SQL queries with joining tables and specific aggregation functions.