Capgemini interview question

Mainly about SQL , Java, and real time scenarios from previous project.