Oracle Interview Question

Puzzle type question which was quite unexpected:)