Week 7 Access Quiz 5

10 Questions | Total Attempts: 182

SettingsSettingsSettings
Please wait...
Internet Quizzes & Trivia

Questions and Answers
  • 1. 
    It's a good idea to think of a relationship as having "sides
    • A. 

      True

    • B. 

      False

  • 2. 
    To create a one-to-many relationship, you:
    • A. 

      Use a junction table with at least two foreign key fields.

    • B. 

      Turn off indexing for the primary key field.

    • C. 

      Use the primary key from the table on the "one" side as a foreign key in the table on The "many" side.

  • 3. 
    To create a one-to-one relationship, you:
    • A. 

      Turn off indexing for the foreign key field.

    • B. 

      Enable referential integrity

    • C. 

      Turn on indexing for the foreign key field without allowing duplicate values.

    • D. 

      Turn on indexing in the foreign key field, but allow duplicate values.

  • 4. 
    Referential integrity is useful because it:
    • A. 

      Allows you to "orphan" data safely.

    • B. 

      Keeps primary and foreign key values in synch.

    • C. 

      Takes the place of an index.

  • 5. 
    To create a many-to-many relationship between Table A and Table B, you:
    • A. 

      Add the primary keys from A and B to a "link" or "junction" table.

    • B. 

      Add as many fields as needed from table A to table B, and vice versa, until each table contains all the data you need to track.

    • C. 

      Create one-to-one relationships between A, B, and at least two other tables.

  • 6. 
    What is the function of a primary key?
    • A. 

      To uniquely identify each record in a table.

    • B. 

      To help ensure you enter data in the correct table.

    • C. 

      To encrypt and decrypt your database.

  • 7. 
    A good database design helps ensure that your data is:
    • A. 

      Complete and accurate.

    • B. 

      Duplicated so it's easier to find.

    • C. 

      Always backed up.

  • 8. 
    You should always place all your data in separate tables.
    • A. 

      True

    • B. 

      False

  • 9. 
    You establish a relationship between Table A and Table B by:
    • A. 

      Merging Table A with Table B.

    • B. 

      Linking Table A with Table B.

    • C. 

      Adding the primary key from Table A to Table B (or vice-versa).

  • 10. 
    How many tables should a well-designed database contain?
    • A. 

      One, with many fields.

    • B. 

      Two.

    • C. 

      many as necessary to capture all your data without redundancy.

Back to Top Back to top