Relational Databases vs Flat Files Quiz

What is a primary key in a relational database?

• A unique identifier for each record in a table

• A field that can contain duplicate values

• A key that is used to encrypt data

• A key that links two tables together

Which of the following are benefits of using relational databases?

• They are easier to set up than flat files

• They allow for complex queries and data relationships

• They require less storage space than flat files

• They do not require a database management system

What is a drawback of relational databases compared to flat files?

• They are less secure

• They are more difficult to update

• They are more complex to create and manage

• They cannot handle large amounts of data

In a relational database, what is a foreign key?

• A key that is used to encrypt data

• A field that uniquely identifies each record in a table

• A key that links two tables together

• A key that is used to sort data

Which of the following is a characteristic of flat files?

• They support complex queries

• They have a fixed structure

• They allow for data relationships

• They require a database management system

How do relational databases handle data redundancy?

• By allowing duplicate data in multiple tables

• By using normalisation to minimise redundancy

• By storing all data in a single table

• By using flat file structures

What is SQL used for in relational databases?

• To create graphical user interfaces

• To manage and manipulate data

• To encrypt data

• To design database schemas

Which of the following is NOT a type of relationship in a relational database?

• One-to-one

• One-to-many

• Many-to-many

• One-to-none

What is the purpose of normalisation in relational databases?

• To increase data redundancy

• To simplify database queries

• To organise data to reduce redundancy and improve integrity

• To create flat file structures

Which of the following is a disadvantage of flat files compared to relational databases?

• They are more complex to set up

• They do not support data relationships

• They require more storage space

• They are less secure