Oracle Interview Question

One of the technical question