Oracle interview question

Detailed discussion on background.