Oracle interview question

more on the designed pattern