Question 1

Looking up a zip code from a zipcode table to find a city and state from a zip in a customer table is an example of:

Group of answer choices

A. a one-to-many join

B. a one-to-one join

C. left join

D. None of these answers are correct

Question 2

In an example of a student table with a table of all classes students have taken. Returning classes for each student, which table would be acting as the parent?

Group of answer choices

A. student

B. classes

C. Either is a parent

D. Neither is the parent

Question 3

Type of join that excludes parent records if no child exists.

Group of answer choices

A. Left Outer

B. Right Outer

C. Inner

D. None of these answers

Question 4

In a one-to-many relation, you always have one or more child records.

Group of answer choices

A. True

B. False

Question 5

Similar to a programmer's flow chart, a(n) ________ maintains a visual representation of the relationships between tables.

Group of answer choices

A. IPO

B. ERD

C. TOE

D. None of these are correct

Question 6

A Foreign Key is found in the parent pointing to a matching record in the child.

Group of answer choices

A. True

B. False

Question 7

Customer.LastName

In this example, Customer is a column name

Group of answer choices

A. True

B. False

Question 8

Join field data types (i.e. int-int, varchar(20)-varchar(20)) need to match in between the parent and child fields being joined.

Group of answer choices

A. True

B. False

Question 9

Type of JOIN used to locate orphan child records (because they return null data).

Group of answer choices

A. Inner

B. Left Outer

C. Cross

D. None of these are correct

Question 10

You can only JOIN one table to a parent at a time.

Group of answer choices

A. True

B. False