1. The join that returns all records from the left table and matching records from right table in the result set is referred to as:

1. Left outer join
2. Right outer join
3. Full outer join
4. Cross outer join

2. A ______ clause is used to combine rows from two or more tables, based on a related column between them:

1. Add
2. Join
3. Link
4. None of the above

iii. Which SQL keyword is used to change the structure, properties or constraints of a table?

1. SET
2. CREATE
3. SELECT
4. ALTER