Oracle interview question

Questions are from Database, algorithm & puzzles.