Database Integrity (1)

Why is it important to keep relationship data in order?

• To speed up data processing

• To prevent inconsistencies

• To enhance programming skills

• To improve data visualisation

Answer explanation

Keeping relationship data in order is important to prevent inconsistencies, ensuring data accuracy and reliability.

What can cause major problems according in databases?

• Slow internet connection

• Inconsistencies in data

• Outdated software

• Lack of programming knowledge

Answer explanation

Inconsistencies in data can cause major problems in databases by leading to errors, inaccuracies, and unreliable information.

What is the significance of referential integrity in relationship data?

• It reduces the size of the database

• It ensures data is visually appealing

• It guarantees faster data access

• It maintains data in an ordered manner

Answer explanation

Referential integrity in relationship data maintains data in an ordered manner by enforcing consistency and accuracy in the relationships between tables.

How does normalisation benefit a database system?

• By allowing duplicate data

• By reducing data redundancy and improving data integrity

• By increasing the size of the database

• By making the database system more complex

Answer explanation

Normalization benefits a database system by reducing data redundancy and improving data integrity.

What role does indexing play in database performance?

• Decreases search speed

• Increases storage requirements

• Improves the speed of data retrieval operations

• Has no impact on performance

Answer explanation

Indexing improves the speed of data retrieval operations by allowing for faster access to specific data within a database.

Which of the following best describes the purpose of foreign keys in a database?

• To uniquely identify each row in a table

• To enhance the visual appearance of the data

• To establish a link between two tables

• To increase the processing speed of queries

Answer explanation

Foreign keys in a database are used to establish a link between two tables, allowing for relationships and data integrity.

What is the primary purpose of using transactions in database operations?

• To increase the complexity of database operations

• To ensure data integrity and consistency in case of a failure

• To decrease the speed of database operations

• To limit the access of data to certain users

Answer explanation

Using transactions in database operations ensures data integrity and consistency in case of a failure by allowing all changes to be made as a single unit or none at all.

Why are backup and recovery procedures important in database management?

• To make the database operations more complex

• To reduce the storage space used by the database

• To ensure data availability and integrity in case of system failure

• To improve the aesthetics of the database interface

Answer explanation

Backup and recovery procedures are important in database management to ensure data availability and integrity in case of system failure.

How do triggers contribute to database functionality?

• By reducing the amount of storage needed for the database

• By making the database easier to navigate

• By automatically performing a specified action in the database when certain conditions are met

• By increasing the time it takes to retrieve data from the database

Answer explanation

Triggers contribute to database functionality by automatically performing a specified action in the database when certain conditions are met.

What is the primary function of a database management system (DBMS)?

• To manage the storage space on the hard drive

• To facilitate easy retrieval and storage of data

• To enhance the graphical user interface of applications

• To increase the processing power of the computer

Answer explanation

The primary function of a database management system (DBMS) is to facilitate easy retrieval and storage of data, making it the correct choice.