Oracle Interview Question

One puzzle