Oracle interview question

Some puzzles, i dont recall but were basic to verify analytics.