Freddie Mac interview question

Difference between in and exist in oracle