IGATE Interview Question

UNIX shell script related question : use of AWK/SED commands? Difference between materialized view and normal view?