Oracle interview question

Was asked to do a case study.