Multiple Choice Quiz

Click on the correct response for each question below.

1		Which of the following does not follow the relational database model?
			A)	Access
			B)	Excel
			C)	relational database management system
			D)	all of the above follow the relational model.
2		In defining relationships, if the primary table’s primary key is an AutoNumber data type, the related foreign key must be which data type?
			A)	AutoNumber
			B)	Look up
			C)	Long integer
			D)	Short integer
3		Access allows you to set properties for:
			A)	fields
			B)	tables
			C)	database
			D)	all of the above.
4		A credit limit maximum value of $5,000.00 is an example of:
			A)	a field property
			B)	a business rule
			C)	a table property
			D)	a database property
5		Which of the following is not a reason to plan out the database design before entering it into Access?
			A)	once you define a table, it can not be modified
			B)	you can eliminate problems, like data redundancy
			C)	you can ensure that primary and foreign keys have the correct attributes
			D)	you have a clear idea of the relationships between related tables