Denave Interview Question

SQL- JOINS, Union vs Union ALL, Key constraints