Oracle interview question

design, coding and time-complexity based questions