Oracle and OFSS had come for campus recruitment in August '16. There was a 1 and a half hour combined test for all profiles of Oracle India and OFSS consisting of everything from aptitude, reasoning, verbal to coding and technical etc. They had various criteria for shortlisting students for various profiles. For associate consultant, they weren't concerned at all about coding/technical.
Since I'm a mechanical engg, they asked me A LOT about the basics. The questions then shifted to GK and Current affairs and then towards SQL.