IBM interview question

1. SQL things: Left Join, View 2. OOD Concepts 3. More about my technical background