I applied online. The process took 3 weeks. I interviewed at Expedia Group (Geneva) in Mar 2013
Interview
2 interviews that did not reflected at all my skills and capabilities:
They were too academic oriented and definately too far from day to day working skills.
Therefore, 20 mns after the phone call, with pressure loss and with little google help, I was able to find all answers with no difficulties.
Smart people doesn’t learn by heart solutions, but create solutions (I was assuming Expedia was looking for smart people)
Questions:
1_ What is Referential integrity?
2_ What is Entity integrity?
3_ What is correlated sub-query?
4_ How to find differences between 2 queries
5_ How to implement 1-1 1-many and many-many relation?
6_ Difference between PK and Uniq Key?
7_ Difference between clustered, non-clustured index?
8_ What does mean ‘no lock’ expression?
9_ Difference between Delete and truncate?
10_ Different join possible in SQL-server?
11_ What is a deadlock?
12_ What is an entity relationship Diagram?
Second phone interview:
1_ A table with column employee and a column ‘salary’ How to get the name of the fourth most paid employee (see big data solution)
2_ How to remove duplicates data in table with no PK (see big data solution)
3_ Difference between delete and truncate on SQL server
4_ 2 tables sharing same PK. Table A: id 1 and 2, Table B: id 2 and 4
Query listing id in table A but not in table B (in our example –> id 1 only)
Interview questions [1]
Question 1
15 theorical questions with no interest on 12 years of IT experience