A Level Database Concepts Quiz

What is the definition of a database according to the provided learning material?

• A) A temporary collection of unrelated data

• B) A persistent organised store of related data

• C) A random assortment of data

• D) A volatile store of unrelated data

In what forms can data be stored in a database?

• A) Only in a single table

• B) Only in a collection of tables

• C) In a single table or a collection of tables

• D) In a single file

What is a collection of data that relates to an entity (e.g. students) called?

• Record

• Field

• Table

• Field Name

What term is used to describe a collection of data about a single entity (e.g. a student)?

• Table

• Record

• Field

• Field Name

What is a unique piece of data about an entity (e.g. student surnames) called?

• Table

• Record

• Field

• Field Name

What is an entity in the context of databases?

• A characteristic of a field

• A table in a database

• Something in the real world that we store data about

• A type of database

What is one instance of an entity in a database called?

• A field

• A record

• An attribute

• A table

If the entity is a person, which of the following could be an attribute?

• The database

• The table

• Their surname

• The record

What does CRUD stand for in the context of databases?

• Create, Read, Update, Delete

• Create, Retrieve, Update, Delete

• Create, Read, Upload, Delete

• Create, Retrieve, Upload, Delete

What is the purpose of a Database Management System (DBMS)?

• To directly access the database without any intermediate program

• To separate the database from the application(s) that use the database

• To store data in a non-relational format

• To manage network connections