Oracle Interview Question

more on the designed pattern