We had someone apply to be a DBA once, and we handed them a piece of paper and a pencil and asked them to write SQL to connect all of the entries in the table Students with the appropriate entries in the table Grades, and explain to us what would happen, if some students had no grades.
And they couldn't do it and got upset and left.