How would you answer an interview scenario involving First, Single, and OrDefault variants in LINQ?

For lookup by unique email, explain when SingleOrDefault is appropriate and why a database constraint still matters.