Match the following join types to their descriptions:

I. Unequal join
II. Inner join
III. Outer join
IV. Left outer join
V. Right outer join

A. can be created only in SQL view
B. used when you want to display all of the records on the one side of a one-to-many relationship
C. allows only the records where the value in a common field exists in both related tables to be displayed
D. used when you want to display all of the records on the many side of a one-to-many relationship
E. typically used to display records from both tables

A, C, E, B, D

Computer Science & Information Technology

You might also like to view...

Options for changing row height and column width are in the Table Tools contextual Design tab

Indicate whether the statement is true or false

Computer Science & Information Technology

What is an external sort?

What will be an ideal response?

Computer Science & Information Technology