Expedia Group Senior Database Developer interview questions

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)