Joining Tables Answers

What is the default join type?

inner

self join

left outer

right outer

If two tables do not already have relationships, how can they be related in the Design view?

Establish primary keys for both of the tables.

Right-click the table title and then click link tables.

Drag and drop a field from one table to another.

Make sure that only one table has a primary key.

What records will appear for a left outer join with a primary table called OrderItems and a foreign table called Orders?

all Orders records

all OrderItems records

only matching OrderItems records

all of the Orders and OrderItems records

When creating a self-join query in Design view, what is the benefit of giving one of the tables an alias?

An alias is necessary because the tables will be overwritten or deleted.

An alias is necessary because the query will use two sets of primary keys.

An alias is helpful because having two copies of the same table can be confusing.

An alias is helpful because both tables will be deleted after the query is completed.

What symbol next to the records indicates that a table includes a subdatasheet?

an asterisk

a plus sign

a question mark

an exclamation point

Did you find these answers helpful?

More from this Course

Instruction

Instruction

Designing a Relational Database