Referential Integrity MCQ Quiz

What is meant by data integrity?

• The speed of database queries

• The maintenance of accuracy and consistency of data

• The number of users accessing a database

• The size of a database

Referential integrity ensures that:

• Data is stored efficiently

• Tables are indexed correctly

• Relationships between tables remain consistent

• Queries run quickly

Which of the following best describes a foreign key?

• A unique identifier in a table

• A field that links to a primary key in another table

• A duplicated field in the same table

• A calculated value

What problem can occur if referential integrity is NOT enforced?

• Faster processing speeds

• Orphan records

• Increased storage capacity

• Improved accuracy

An orphan record is:

• A duplicated record

• A record with missing data

• A record with no matching related record

• A deleted record

What does a cascade delete do?

• Prevents any deletion from occurring

• Deletes only the primary record

• Automatically deletes related records in other tables

• Backs up the database

Why might cascade delete be dangerous?

• It slows down queries

• It can delete more data than intended

• It increases storage use

• It prevents updates

Which scenario best demonstrates referential integrity?

• A student’s name is stored twice

• A salary record exists without an employee

• A student record must match an existing tutor group

• A table has no primary key

Why is referential integrity important in multi-user databases?

• It reduces hardware costs

• It ensures consistency during simultaneous transactions

• It increases the number of users

• It improves user interfaces

What would happen if a record is added to a child table without a matching parent record (with referential integrity enforced)?

• The record is accepted

• The database crashes

• The record is rejected

• The table is deleted