Saint-Gobain Interview Question

What is MVC? What is union all What is temporary table and global table?