A-level Referential Integrity

Which statement accurately describes the role of user access rights in a database?

• Access rights can be ignored if the database is small.
• Some users can only query the database and run reports.
• User access rights are irrelevant to data integrity.
• All users have the same access to all data.

What does maintaining data integrity in a multi-user database prevent?

• Data from being lost.
• Inconsistent data that can lead to a loss of accuracy.
• Users from accessing the database.
• Data from being stored.

What is a consequence of inconsistent data in a database?

• It can improve data retrieval speed.
• It can reduce the amount of data stored.
• It can lead to a loss of accuracy in the database.
• It can increase user access rights.

What is the primary goal of maintaining consistency in a relational database?

• To ensure data remains accurate and reliable.
• To improve data retrieval speed.
• To allow for unlimited data storage.
• To increase the number of users accessing the database.

Which of the following best describes data integrity?

• The amount of data a database can hold.
• The ability to recover lost data.
• The maintenance and consistency of data in a data store.
• The speed at which data can be accessed.

What is the primary purpose of enforcing referential integrity in a database?

• To allow unlimited user access.
• To ensure the accuracy and consistency of data.
• To increase the speed of data processing.
• To store data in multiple formats.

What does referential integrity ensure in a relational database?

• The ability to store unlimited data.
• The accuracy and consistency of data within a relationship.
• The security of user access rights.
• The speed of data retrieval.

How does referential integrity affect data consistency?

• It allows for the storage of unlimited data.
• It increases the speed of data retrieval.
• It ensures that all related data is accurate and consistent.
• It prevents users from accessing the database.

What is a potential issue with manually deleting records in a database?

• It is always accurate.
• It can lead to mistakes and inconsistencies.
• It improves data integrity.
• It allows for faster data retrieval.

How can referential integrity prevent orphaned entries in a database?

• By encrypting sensitive data.
• By deleting all records at once.
• By ensuring that all records have matching entries in related tables.
• By allowing multiple users to access the same data.