Freddie Mac Interview Question

Difference between in and exist in oracle