Denave interview question

SQL- JOINS, Union vs Union ALL, Key constraints