Click on the correct response for each question below.

1		The 1:8 in a table relationship identifies
			A)	how many records in the first table are related to how many records in the second table.
			B)	the total number of records.
			C)	the total number of tables.
			D)	the total number of records followed by the total number of tables.
2		In the design phase of relational database development, many-to-many relationships
			A)	must be combined into a one-to-one relationship.
			B)	must be broken into multiple one-to-one relationships.
			C)	must be combined into a one-to-many relationship.
			D)	must be broken into multiple one-to-many relationships.
3		Adding or changing the properties of relationships is governed by
			A)	join properties.
			B)	the primary table.
			C)	related fields.
			D)	referential integrity.
4		Which of the following is not a correct statement?
			A)	The parent cannot be deleted while it still has children
			B)	The parent cannot be removed while it still has children.
			C)	The parent must be deleted before the children
			D)	The parent key must exist before the child can use that key
5		This is not one of the Referential integrity options in the Edit Relationships dialog box.
			A)	Cascade Delete Related Records
			B)	Create Referential Integrity
			C)	Enforce Referential Integrity
			D)	Cascade Update Related Fields
6		A relationship is deleted using this window.
			A)	Edit
			B)	Format
			C)	Relationship
			D)	Tools
7		Dragging from the primary key field of one table to a nonkey field in another table builds this relationship.
			A)	One-to-one
			B)	Many-to-many
			C)	One-to-many
			D)	Many-to-one
8		Access automatically creates these on primary key fields defined in the Design view of a table.
			A)	Records
			B)	Indexes
			C)	Tables
			D)	Properties
9		When database performance needs to be improved, you might consider indexing fields with all of the following qualities except
			A)	when frequent searches are executed for values stored in the field.
			B)	the field contains many different values.
			C)	the field is seldom used to sort.
			D)	when frequent searches are executed for values stored in the field.
10		Which of the following is not a correct statement?
			A)	You can track database performance by asking users to document response times and their satisfaction with specific operations.
			B)	Upper-level management can review the indexing to help determine if maximum database performance is being achieved.
			C)	Third-party vendors provide the most comprehensive performance tools that can be used to verify execution and response ties before and after indexing.
			D)	The Performance Analyzer suggests updates that could improve database performance with no indication of the degree of improvement likely.