Oracle Interview Question

Questions are from Database, algorithm & puzzles.