Referential Integrity

What is the purpose of referential integrity?

• To maintain the consistency of data in a database
• To increase the storage capacity of a database
• To improve the performance of database queries
• To secure the data in a database

Why is data integrity important in a database?

• To ensure the accuracy and reliability of the data
• To reduce the storage space required for the database
• To speed up the data retrieval process
• To prevent unauthorized access to the data

What does referential integrity refer to?

• The accuracy and consistency of data within a relationship
• The size and complexity of a database
• The security measures implemented in a database
• The speed and efficiency of database operations

How can referential integrity be maintained when deleting a record from a database?

• By using cascade delete restraints
• By manually removing all related records
• By increasing the database storage capacity
• By running regular data integrity checks

What can happen if referential integrity is not maintained?

• The database can become inconsistent or corrupt
• The database can become too slow to handle queries
• The database can run out of storage space
• The database can be accessed by unauthorized users

What is one potential drawback of using cascade delete restraints?

• Accidentally deleting related records that should not be deleted
• Slowing down the database performance
• Increasing the storage space required for the database
• Making the database more vulnerable to security breaches

In the example of a bank database, which tables are involved in maintaining referential integrity?

• Employee details table and employee salary table
• Customer details table and transaction history table
• Bank branch table and customer account table
• Loan application table and credit score table

What is the purpose of the employee salary table in the bank database example?

• To store information about the bank's employees
• To track the salary changes of the bank's employees
• To calculate the total salary expenses of the bank
• To provide salary information for employee reports

How can referential integrity be maintained when adding a record to a database?

• By ensuring there is a matching record in the related table
• By increasing the database storage capacity
• By running regular data integrity checks
• By manually creating the necessary related records

What is the main goal of data integrity?

• To ensure the accuracy and consistency of data
• To increase the storage capacity of a database
• To improve the performance of database queries
• To secure the data in a database