Sogeti Associate Consultant interview questions

"Asked me to develop queries for SQL around a schema he developed off top of the head. He would add on to it, like now how would you set up your tables and queries if you wanted the time of the transactions?" "Told him I had parallel programming courses. Asked what thrashing was in the caches. Asked what locks were used for." Then object oriented questions for C#. What is an interface? What is modular and coupling? Can't remember the rest, he was impressed by the database knowledge.