Oracle Interview Question

There were 2 coding questions.