A2 Flat and Relational Database Concepts Retrieval

What is a primary disadvantage of a flat file database?

• Efficient data retrieval

• High data integrity

• Data redundancy

• Complex relationships

In a relational database, what uniquely identifies a record in a table?

• Composite key

• Primary key

• Attribute

• Foreign key

Which of the following is NOT a degree of relationship in databases?

• One-to-One

• Many-to-One

• One-to-Many

• Many-to-Many

What ensures that every foreign key value corresponds to a valid primary key value?

• Data Integrity

• Referential Integrity

• Data Dictionary

• Data Duplication

Which term describes a data item within an entity?

• Entity

• Foreign key

• Attribute

• Primary key

What is a composite key?

• A key that is always a primary key

• A key that consists of a single attribute

• A key that consists of more than one attribute

• A key that is always a foreign key

Which of the following is an advantage of relational databases?

• Requires less specialist knowledge

• Minimized data inconsistency

• Complex query setup

• Increased data redundancy

What is the role of a foreign key in a relational database?

• To store data redundantly

• To link tables together

• To uniquely identify a record

• To ensure data inconsistency

What is the purpose of a data dictionary?

• To store actual data

• To create data inconsistency

• To describe data held in a database

• To ensure data redundancy

Which of the following describes data integrity?

• Data is inconsistent

• Data is stored in a single file

• Data is accurate and reliable

• Data is entered multiple times