Oracle interview question

Resume deep-dive + 1 coding with 2-3 follow ups.