Database Relationships  «Prev 

Database Relationships[Access] - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which type of relationship uses a junction table?
Please select the best answer.
  A. One-to-many
  B. One-to-one
  C. Many-to-many
  D. Many-to-one

2. How do key fields work with a one-to-one relationship between two tables?
Please select the best answer.
  A. The first table uses the primary key field, and the second table uses a foreign key field.
  B. The first table uses the foreign key field, and the second table uses a primary key field.
  C. Both tables use primary key fields.
  D. Neither table uses primary key fields.

3. How does a many-to-many relationship differ from the other two kinds of relationships?
Please select the best answer.
  A. Primary key fields are used for both sides of the relationship.
  B. Three tables are used instead of two tables.
  C. You can’t use referential integrity.
  D. No primary key fields are used.

Correct answers:

Your Score: 0