Oracle interview question

Nothing difficult or unexpected if you prepare.