Oracle Interview Question

2 coding, 3/4 short questions