Some SQL queries - hand written - with a fake db schema. 8-10 oral interview questions with a mix of technical and situational questions. The standard, "Why do you want this job and why are you qualified?" question...