Matching
Match the following terms with their description:
Premises:
Cascade Update
Referential Integrity
Cascade Delete
AutoNumber
Data Redundancy
Responses:
Deletes records in related fields that match the primary key
Increases by one each time a record is added
When the same data is stored in two or more tables
Rules which preserve table relationships when key values change
Changes key value in related tables if key value in primary table is changed
Correct Answer:
Premises:
Responses:
Cascade Update
Referential Integrity
Cascade Delete
AutoNumber
Data Redundancy
Premises:
Cascade Update
Referential Integrity
Cascade Delete
AutoNumber
Data Redundancy
Responses:
Related Questions
Q53: It is best when designing a query
Q54: What option automatically deletes records in related
Q55: The _ field type makes a good
Q56: Text you add to the criteria row
Q57: Which of the following cannot be imported
Q59: One way to fix the problem that
Q60: You can easily _ your data by
Q61: For security purposes you want to have
Q62: The _ property provides literal characters that
Q63: The _ sign should be put around