Oracle interview question

Describe how you would proceed in this specific task.