Q1. Which describes the following? Return all values from 2nd table and only corresponding values from the 1st table. If 1st table does not match, nulls are provided.

a. Cross Join b. Self Join c. Inner Join d. Left Outer Join e. Right Outer Join

Q2. Which describes the following? Matching values from both tables.

a. Self Join b. Full Outer Join c. Inner Join d. Left Outer Join e. Right Outer Join

Q3. Which describes the following? Return all values from 1st table and only corresponding values from the 2nd table. If 2nd table does not match, nulls are provided.

a.Self Join b. Cross Join c. Inner Join d. Left Outer Join e. Right Outer Join

Q4. When joining more than 2 tables, what rule is true?

a. All tables must be related to each other

b. Every table must be related to at least one table.

c. A table does not have to be related.

d. There must be one table that is directly related to all other tables.

Q5. Can you update or delete data in a table using a join?

a. YES b. NO

Q6. Can you update or delete data in a table using a join?

a. YES b. NO

Q7. When using a join, which option is true about the joining columns in each table.

a. Must have the same name b. Must have the same data type

c. Must have the same name and data type. d. Must have a PK FK relationship.

e. Must have been joined in the past.