Oracle Interview Question

Basics of some SQL joins. Some basic algorithms.