Antra interview question

SQL conceptions like stored procedure, join vs union