Database Referential Integrity Quiz

What is the process of maintaining the consistency of the database known as?

• Data security

• Data normalization

• Data integrity

• Data validation

What is the key technique for ensuring data integrity in a relational database?

• Data indexing

• Data compression

• Referential integrity

• Data encryption

In the example given, what information does the 'employee details' table hold?

• Student records

• Tutor group details

• Employee salary information

• Employee's name

What is the purpose of enforcing a cascade delete restraint on the primary key relationship between tables?

• To ensure data consistency

• To speed up data retrieval

• To increase database size

• To prevent any deletions

What could happen if a cascade delete restraint is used on the relationship between the tutor group and student tables?

• The database will crash

• No records will be deleted

• All records of students in the tutor group will be deleted

• Only the tutor group record will be deleted

What does referential integrity help to ensure in a database?

• Data corruption

• Data accuracy

• Data duplication

• Data loss

What is the main concern when using referential integrity restraints like cascade delete?

• Data validation

• Data normalization

• Data security

• Data inconsistency

What is the purpose of the employee salary table in the example given?

• To store employee names

• To store tutor group details

• To store employee salary information

• To store student records

What is the risk of manually removing an employee from the employee's salary table?

• Data loss

• Data corruption

• Data duplication

• Data inconsistency

What is the definition of data integrity?

• The process of adding data to a database

• The maintenance and consistency of data in a data store

• The process of deleting data from a database

• The process of querying data from a database