AQA A-Level Computer Science - Databases

What is the primary function of a database?

• To store backup data

• To analyse data

• To store and organise information

Which of the following is TRUE about flat-file databases?

• A flat-file database has only one table.

• A flat-file database has many tables that are not related to each other.

• A flat-file database has many tables connected to each other with a relation.

Which of the following is a software that is used to create and manage database?

• MySQL

• Oracle

• Microsoft Access

• All of the above

What is structured data?

• Data that is stored in pre-defined format

• Data that is not stored in pre-defined format

• A unique identifier for record in a table

• A type of database

The highlighted row is called a...

• Record

• Field

• Data

What is the column with the title "Date of Joining" called?

• Record

• Field

• Data

Which column is best suited for a primary key?

• Employee number

• Employee name

• Date of birth

What is the function of a primary key?

• It uniquely identifies a record.

• It uniquely identifies a field.

• It uniquely identifies a table.

Which of the following is true about a relational database?

• A database with one large table.

• A database with unique tables that are related to each other.

• A set of unique databases related to each other.

Which of the following is NOT a characteristic of relational database?

• Each table contains information about many entities.

• The tables in a relational database are related to each other using primary and foreign keys.

• A record stores attributes of an entity.

• All of the above