Fractal Interview Question

plsql questions.. on views a scenario will be given