Database Management for Year 4 Primary School Students in the UK

Question 1

Imagine we have a database with a table of students. Each student has a name and an ID number. What is the main reason we use the ID number in this database?

Accepted Answer

To help us tell the students apart.

Answer

To store the student's name.

Answer

To sort the students by their age.

Answer

To connect this database to other databases.

Question 2

How is data organized in a database?

Accepted Answer

In rows and columns like a table

Answer

Like a list

Answer

In a chart with lines

Answer

Randomly

Question 3

What's the main reason we use databases?

Accepted Answer

To keep information organized

Answer

To make documents

Answer

To send messages

Answer

To play games

Question 4

What is an advantage of using a database?

Accepted Answer

You can quickly find the information you need.

Answer

It is difficult to change information.

Answer

Databases are not secure.

Answer

Databases are expensive.

Question 5

Imagine a database as a library full of books. Each book has a unique code, like a secret ID number. What is the purpose of this unique code in a database?

Accepted Answer

It helps us find a specific book quickly, like using the ID number to find a particular book on the library shelf.

Answer

It contains all the important details about each book.

Answer

It tells the librarian how to arrange the books on the shelves.

Answer

It protects the books from being lost or damaged.

Question 6

When we use a database, our data is stored together in one place. This can make it easier to find and change the data we need. Which of these is a disadvantage of using a database?

Accepted Answer

It means we can only have the data in one place.

Answer

It helps us to keep our data organized.

Answer

It helps us to keep our data safe.

Answer

It allows us to share our data with others easily.

Question 7

What type of data CANNOT be stored in a database?

Accepted Answer

Computer programs, like games or apps

Answer

Text, such as your name

Answer

Numbers, like your age

Answer

Pictures, like a photo of your pet

Question 8

In a database, what do we call the vertical columns of information?

Accepted Answer

Fields

Answer

Rows

Answer

Tables

Answer

Data types

Question 9

What is the purpose of a database?

Accepted Answer

To gather and organize a large amount of information in one location

Answer

To run specific computer programs

Answer

To create tables and charts

Answer

To store information on the internet

Question 10

What types of information can be stored in a database?

Accepted Answer

Names

Accepted Answer

Birthdates

Accepted Answer

Phone numbers

Answer

Pictures

Question 11

What is a database?

Accepted Answer

A collection of data organized into tables

Answer

A list of names and addresses

Answer

A program that allows you to create and edit documents

Answer

A website that stores information about people

Question 12

What is the main purpose of a primary key in a database?

Accepted Answer

To make sure each row in a table is unique

Answer

To store the most important data in a table

Answer

To organize rows in a specific order

Answer

To calculate values for other fields

Question 13

Which of the following is NOT a part of a database used to organize and store data?

Accepted Answer

Spreadsheet

Answer

Records

Answer

Tables

Answer

Fields

Question 14

Which type of information cannot be stored in a database?

Accepted Answer

The smell of flowers

Answer

Names of people

Answer

Scores in a game

Answer

Pictures of pets

Question 15

What is the main purpose of a database?

Accepted Answer

To store information, like a library stores books

Answer

To send messages to friends

Answer

To play games

Answer

To draw pictures

Question 16

Why do we need a primary key for each table in a database?

Accepted Answer

To ensure each record in the table is unique.

Answer

To store the most important information in the table.

Answer

To help us sort the records in the table.

Answer

To connect the table to other tables in the database.

Question 17

What's the main reason for using a primary key in a database?

Accepted Answer

To make sure each record is different

Answer

To keep the most important information

Answer

To put the data in a certain order

Answer

To find the average of a field

Question 18

In a database, how do you ensure that each piece of information has its own unique identifier?

Accepted Answer

Assign a unique value to a specific field for each piece of information.

Answer

Leave one field blank.

Answer

Use the same field for all information.

Answer

Let the database automatically generate a name for a field.

Question 19

In a database, which field uniquely identifies each record?

Accepted Answer

Primary key

Answer

Title

Answer

Description

Answer

Category

Question 20

In a database, each horizontal line of data in a table is called a:

Accepted Answer

Record

Answer

Field

Answer

Block

Answer

Column

Question 21

What types of information can you store in a database?

Accepted Answer

Words, numbers, and pictures

Answer

Only words

Answer

Only numbers

Question 22

Why do people use databases?

Accepted Answer

To organize and store information

Answer

To play games

Answer

To send messages

Answer

To print pictures

Question 23

Which of the following is NOT an advantage of using a database?

Accepted Answer

Difficult to access and retrieve data

Answer

Easy to store and organize data

Answer

Can be shared and used by multiple users

Answer

Saves time and effort in managing data

Question 24

In a database, which field ensures that each row of data is unique?

Accepted Answer

Unique identifier

Answer

Row number

Answer

Table title

Answer

Most important information

Question 25

What is the most important reason why we use databases?

Accepted Answer

To store and organize information

Answer

To keep track of our belongings

Answer

To entertain ourselves

Question 26

Imagine you have a classroom full of students. How can you easily tell them apart?

Accepted Answer

By their names

Answer

By their birthdays

Answer

By their hair color

Answer

By their favorite subject

Question 27

In a database, what do we call each type of information, like name or age?

Accepted Answer

Field

Answer

Record

Answer

Data point

Question 28

In a database, which part contains all the data?

Accepted Answer

Table

Answer

Row

Answer

Field

Question 29

Which of these is NOT an advantage of using a database over a spreadsheet?

Accepted Answer

Performing math calculations

Answer

Keeping data safe and secure

Answer

Organizing large amounts of data

Answer

Finding information quickly

Question 30

In a database, the data is organized into different sections. What are these sections called?

Accepted Answer

Tables

Answer

Files

Answer

Records

Question 31

What is a collection of data that is organized to make it easy to find and use?

Accepted Answer

A database

Answer

A filing cabinet

Answer

A library

Answer

A computer program

Question 32

Which of these is NOT a component of a database?

Accepted Answer

Spreadsheet

Answer

Records

Answer

Fields

Answer

Tables

Question 33

What is a database?

Accepted Answer

A special list that stores information

Answer

A computer program

Answer

A way to send messages online

Question 34

In a database, what do we call each of the categories listed across the top?

Accepted Answer

Fields

Answer

Rows

Answer

Records

Answer

Tables

Question 35

Which of these is a disadvantage of using a database?

Accepted Answer

It is difficult to keep the data up to date.

Answer

It is easy to search for and find specific information.

Answer

It can be used to store large amounts of data.

Answer

It can be used to create reports and charts.

Question 36

What's the name of the process used to arrange data in a database in a specific order?

Accepted Answer

Sorting

Answer

Grouping

Answer

Filtering

Question 37

Which of the following is the best example of a database?

Accepted Answer

A table of student names and their grades

Accepted Answer

An address book with names and phone numbers

Answer

A list of your favorite foods

Answer

A collection of photos of your family

Question 38

Databases are like big storage boxes for information, while spreadsheets are like smaller ones. Which of these is true?

Accepted Answer

Databases can hold more information than spreadsheets.

Answer

Spreadsheets are easier to use than databases.

Answer

Databases can only store numbers, while spreadsheets can store both numbers and text.

Answer

Spreadsheets are better for calculations than databases.

Question 39

In a database system, which part helps us create, change, and manage the database?

Accepted Answer

Database Management System (DBMS)

Answer

Data Tables

Answer

Queries

Answer

Forms

Question 40

In a database, what is the smallest unit of data called?

Accepted Answer

Field

Answer

Record

Answer

Table

Answer

Database

Question 41

How can databases be used to protect the environment and make our planet a better place?

Accepted Answer

Databases can help us track our energy use and identify ways to save energy.

Accepted Answer

Databases can store information about endangered species, helping us protect them.

Accepted Answer

Databases can be used to create models of the environment, allowing us to predict the impact of different choices.

Answer

Databases cannot be used to help the environment or save our planet.

Question 42

What is a database?

Accepted Answer

A collection of related data stored and retrieved using a computer program

Answer

A storage device used to keep data files safe

Answer

A program that helps you write letters

Answer

A way to send emails

Question 43

Which of these is NOT a part of a database?

Accepted Answer

Documents

Answer

Fields

Answer

Records

Answer

Tables

Question 44

What is a primary key?

Accepted Answer

A column that uniquely identifies each record in a table

Answer

A field that stores the most important information in a record

Answer

A key that allows you to sort data in a table

Answer

A key that links two tables together

Question 45

Which of these is a database program?

Accepted Answer

Microsoft Access

Answer

Google Drive

Answer

Microsoft Word

Answer

Adobe Photoshop

Question 46

What is a query?

Accepted Answer

A request for specific data from a database

Answer

A program that creates a new database

Answer

A way to edit data in a database

Answer

A tool for designing database reports

Question 47

How do you write a simple query to select all records from a table?

Accepted Answer

SELECT * FROM table_name

Answer

GET ALL FROM table_name

Answer

FETCH * FROM table_name

Answer

READ ALL FROM table_name

Question 48

What is a filter?

Accepted Answer

A condition that limits the data returned by a query

Answer

A way to sort data in a database

Answer

A tool for designing database reports

Answer

A way to create a new table in a database

Question 49

What is the purpose of a database report?

Accepted Answer

To present data from a database in an easy-to-read format

Answer

To create a new database

Answer

To edit data in a database

Answer

To query data in a database

Question 50

What is a database?

Accepted Answer

A collection of related data organized in a specific way

Answer

A type of shoe that has a thick sole

Answer

A tool used to fix computers

Answer

A type of animal that lives in the ocean

Question 51

What is a primary key?

Accepted Answer

A field that uniquely identifies each row in a table

Answer

A field that contains the most important data in a table

Answer

A field that is used to sort the data in a table

Answer

A field that is used to link tables together

Question 52

What is a query?

Accepted Answer

A question that is asked of a database

Answer

A way to create a new table in a database

Answer

A way to edit the data in a table

Answer

A way to delete the data from a table

Question 53

Which of the following is NOT a logical operator that can be used in a query?

Accepted Answer

XOR

Answer

AND

Answer

OR

Answer

NOT

Question 54

What is a form?

Accepted Answer

A way to enter and edit data in a database

Answer

A way to create a new table in a database

Answer

A way to run a query on a database

Answer

A way to print data from a database

Question 55

What is the name of the software used to create and manage databases?

Accepted Answer

Database management system

Answer

Spreadsheet

Answer

Word processor

Answer

Presentation software

Question 56

What is the main reason why databases are important for training AI and ML models?

Accepted Answer

They store the data used to train models.

Answer

They run the algorithms that train models.

Answer

They display the results generated by models.

Question 57

What is data warehousing? How does it help us analyze data and make better decisions?

Accepted Answer

Data warehousing stores data from different sources in one place, allowing us to find patterns and make decisions.

Answer

Data warehousing is not just for personal information.

Answer

Data warehousing is useful even if we don't have a lot of data.

Answer

Data warehousing is not only for big companies.

Question 58

What is a database?

Accepted Answer

A collection of data stored in a structured way making it easy to access and manage.

Answer

A software program used to create and manage data

Answer

A device used to store data

Answer

A specialized type of website

Question 59

Which of the following is NOT a common component of a database?

Accepted Answer

Spreadsheets

Answer

Tables

Answer

Fields

Answer

Indexes

Question 60

What is the purpose of a field in a database?

Accepted Answer

To store a piece of data

Answer

To group related data together

Answer

To index data for quicker searching

Answer

To connect different tables

Question 61

Which of the following best describes the difference between a primary key and a foreign key?

Accepted Answer

A primary key uniquely identifies each record in a table, while a foreign key references a field in another table.

Answer

A foreign key uniquely identifies each record in a table, while a primary key references a field in another table.

Answer

There is no difference between a primary key and a foreign key.

Answer

Both A and B are true.

Question 62

What is a common use of a query in a database?

Accepted Answer

To retrieve specific data from a database

Answer

To add new data to a database

Answer

To delete data from a database

Answer

To update data in a database

Question 63

What is the main purpose of a database schema?

Accepted Answer

To define the structure and organization of a database

Answer

To store the actual data in the database

Answer

To allow users to access and modify data in the database

Answer

To improve the performance of the database

Question 64

Why is indexing useful in a database?

Accepted Answer

It helps speed up data retrieval by organizing data in a specific order

Answer

It reduces the amount of storage space required for the database

Answer

It makes it easier to maintain the integrity of the data

Answer

It allows multiple users to access the database simultaneously