Site MapHelpFeedbackLesson 09 - Building Links, Relationships, and Indexes
Lesson 09 - Building Links, Relationships, and Indexes
(See related pages)

1
You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
A)5
B)8
C)24
D)Not enough information to tell
2
Which of the following types of joins displays records with the same value in the common field?
A)Inner join
B)Left outer join
C)Right outer join
D)Self join
3
A global join will be created automatically when using tables in a(n) _______________.
A)form
B)report
C)query
D)field
4
Which of the following is the default join between two recordsets?
A)Inner join
B)Left outer join
C)Right outer join
D)Self join
5
In a query's Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
A)The join line but not the relationship between the two tables
B)The relationship between the two tables locally
C)The relationship between the two tables globally
D)The primary key of the first table
6
What is an index?
A)A wizard that creates a functional database structure based on the user's selections
B)A widely recognized naming convention for database objects
C)A sort order for records, which is identified in the table design
D)A set of relationship rules that enforce defined database relationships
7
You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
A)7
B)17
C)60
D)Not enough information to tell
8
Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
A)Edit Relationships
B)Indexes
C)Option
D)Show Table
9
In a junction table, the _______________ field consists of the foreign key from both the linked tables.
A)first defined
B)last defined
C)foreign key
D)primary key
10
What does an inner join display?
A)Records from the second recordset and only records from the first recordset where the common fields are equal
B)Records from the first recordset and only records from the second recordset where the common fields are equal
C)Records that have the same value in the common field
D)Records from the first recordset only





To learn more about the book this website supports, please visit its Information Center.
(c)2010 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Notice.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


PAS Office 2007 BriefOnline Learning Center

Home > Access > Lesson 09 Quiz