Oracle Interview Question

question on airline system design