Fractal interview question

plsql questions.. on views a scenario will be given