Oracle interview question

2 coding, 3/4 short questions