Pergunta de entrevista da empresa Capgemini

Write code separating odd and even numbers in table to separate ends, in SQL find all clients with at least 3 projects, Java questions - how to store passwords (byte array), favorite design pattern, SOLID - in your own words, what is coupling (heard cupping - answered comparing coffee ), passed on Spring (was working with Guice before), inner implementation of hashmap, java memory management, difference between orElse/orElseGet example of functional interface (predicate), streams, terminating operations and String comparison questions.