1. Referential integrity refers to the accuracy and consistency of data within a relationship
2. Fill in the blanks for the following excerpt
3. In this example, if we delete record number 15 in a primary table, we need to be sure that ______________________________
4. In reference to the above example, we should only be able to delete a primary key if ______________. Otherwise, we would end up with an orphaned record.
5. Referential integrity ensures the relationships between tables in a database __________________to prevent users or applications from entering inaccurate data or pointing to data that doesn't exist
6. In referential integrity, we would say that every foreign key value has a matching value in the corresponding ____________.
7. Referential integrity uses techniques to ensure that there are no orphan records i.e. it prevents you from ________________
8. Referential integrity can alert you if you try to delete a record which is _____________________
9. The simplest way to enforce referential integrity is ______________ to a primary key
10. Fill in the blanks for the following excerpt
11. When one table has a foreign key to another table, the concept of referential integrity states that you ______________
12. Referential integrity includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are _________________
13. Which of the following are advantages of referential integrity constraints?
14. Read the following excerpt. Which one of the following 'rules' is incorrect?
15. A lack of referential integrity in a database can lead to ______________. This could result in records being “lost” in the database, because they’re never returned in queries or reports