Databases for Year 5: Learn the Basics of Data Management

Question 1

Which of these is not a type of database?

Accepted Answer

A spreadsheet with rows and columns

Answer

A database that stores data in a flat table

Answer

A database that stores data in a tree-like structure

Question 2

Which of these is not a type of database?

Accepted Answer

Spreadsheet

Answer

Relational database

Answer

Hierarchical database

Answer

Network database

Question 3

Which of the following is NOT a type of data field category in a database?

Accepted Answer

Calculation

Answer

Number

Answer

Text

Answer

Image

Question 4

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

Accepted Answer

To uniquely identify each record in a table

Answer

To store personal information

Answer

To create relationships between different tables

Answer

To sort data in ascending order

Question 5

Which of the following is a widely-used software for managing databases?

Accepted Answer

Microsoft Access

Answer

Google Sheets

Answer

Microsoft Word

Answer

Google Chrome

Question 6

What do you call a request for specific data from a database?

Accepted Answer

Query

Answer

Command

Answer

Modification

Answer

Import

Question 7

Which of these is a logical operator commonly used in database queries?

Accepted Answer

AND

Answer

IF

Answer

WHILE

Answer

FOR

Question 8

How do rows and columns differ in a database table?

Accepted Answer

Rows contain records, while columns contain field categories

Answer

Columns contain records, while rows contain field categories

Answer

Rows and columns are the same thing

Answer

There is no difference

Question 9

What is a foreign key in a database table?

Accepted Answer

A field that connects to another field in a different table

Answer

A unique identifier for each record

Answer

A field that stores data from external sources

Answer

A field that links to a website

Question 10

Which of these is an example of a relational database management system (RDBMS)?

Accepted Answer

MySQL

Answer

Microsoft Excel

Answer

Google Forms

Answer

Apple Notes

Question 11

What is the common file extension for Microsoft Access database files?

Accepted Answer

.accdb

Answer

.mdb

Answer

.xlsx

Answer

.doc

Question 12

What does a primary key do?

Accepted Answer

It gives each record in a table a unique name.

Answer

It joins together two different tables.

Answer

It shows the most important data in a table.

Answer

It helps you quickly find specific data.

Question 13

Which data type would you use to store a person's name in a database?

Accepted Answer

String (letters and words)

Answer

Integer (whole number)

Answer

Date

Answer

True/False

Question 14

What's the difference between a query and a report?

Accepted Answer

Queries find data, while reports show data.

Answer

Reports find data, while queries show data.

Answer

They both find and show data.

Answer

They neither find nor show data.

Question 15

Which of these is a database management system?

Accepted Answer

Microsoft Access

Answer

Google Sheets

Answer

Microsoft Word

Answer

Adobe Photoshop

Question 16

What does a foreign key do?

Accepted Answer

It links two tables together.

Answer

It gives each record in a table a unique name.

Answer

It helps you find data quickly.

Answer

It shows additional details about a record.

Question 17

What does a data dictionary do?

Accepted Answer

It tells you about the structure and contents of a database.

Answer

It stores the data in a database.

Answer

It allows you to ask questions about the database.

Answer

It helps you create reports.

Question 18

Which of these is NOT a type of database?

Accepted Answer

Spreadsheet

Answer

Relational database

Answer

Hierarchical database

Answer

Network database

Question 19

Which type of database can store a large amount of interconnected information?

Accepted Answer

Relational database

Answer

Flat-file database

Answer

Spreadsheet database

Question 20

Which of these is NOT a part of a database?

Accepted Answer

Lists

Answer

Tables

Answer

Fields

Answer

Queries

Question 21

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

Accepted Answer

To make sure each record is unique

Answer

To store the most important data

Answer

To group related records together

Answer

To perform calculations on the data

Question 22

What does the acronym SQL stand for?

Accepted Answer

Structured Query Language

Answer

Straightforward Query Language

Answer

Standard Query Language

Answer

Special Query Language

Question 23

Which of these is an example of a query?

Accepted Answer

SELECT * FROM students

Answer

INSERT INTO students (name, age)

Answer

CREATE TABLE students (name TEXT, age NUMBER)

Answer

CHANGE students SET age = age + 1

Question 24

Which of these is NOT a type of database relationship?

Accepted Answer

Parent-child

Answer

One-to-one

Answer

One-to-many

Answer

Many-to-many

Question 25

What is the purpose of an index in a database?

Accepted Answer

To make finding data faster

Answer

To keep data safe

Answer

To store backup copies of data

Answer

To delete unnecessary data

Question 26

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

Accepted Answer

Database management system (DBMS)

Answer

Spreadsheet program

Answer

Word processor

Answer

Graphics editor

Question 27

In a database table, what is the primary key?

Accepted Answer

A unique identifier for each piece of information

Answer

The name of the table

Answer

The first column in the table

Answer

The last column in the table

Question 28

What is the main purpose of a database management system (DBMS)?

Accepted Answer

To make, manage, and use databases

Answer

To store a lot of data in one place

Answer

To create the programs that will run a database

Answer

To help people look at databases

Question 29

In SQL, which sign means "greater than"?

Accepted Answer

>

Answer

<

Answer

=

Answer

>=

Question 30

What does an index do in a database?

Accepted Answer

Makes finding data faster

Answer

Keeps data from being changed

Answer

Stops data from being lost

Answer

Controls who can use the database

Question 31

Which is a common method for designing databases?

Accepted Answer

Normalization

Answer

Denormalization

Answer

Aggregation

Answer

Partitioning

Question 32

Which database type organizes data like a family tree or an organization chart?

Accepted Answer

Hierarchical database

Answer

Relational database

Answer

Network database

Answer

Object-oriented database

Question 33

Which of these is not a common Database Management System (DBMS)?

Accepted Answer

Excel

Answer

Oracle

Answer

Microsoft Access

Answer

MySQL

Question 34

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

Accepted Answer

To uniquely identify each record in a table

Answer

To store extra details about a record

Answer

To link records from separate tables

Answer

To keep the data in the database secure

Question 35

What's the difference between a 'CREATE TABLE' statement and an 'INSERT INTO' statement in SQL?

Accepted Answer

CREATE TABLE makes a new table, while INSERT INTO adds new data to an existing table.

Answer

INSERT INTO makes a new table, while CREATE TABLE adds new data to an existing table.

Answer

Both do the same thing.

Answer

INSERT INTO makes a new database, while CREATE TABLE adds data to an existing database.

Question 36

What does a 'WHERE' clause do in a 'SELECT' statement?

Accepted Answer

It chooses which rows to get from a table.

Answer

It groups the results of a query.

Answer

It puts the results of a query in order.

Answer

It limits the number of results.

Question 37

What's the purpose of a database index?

Accepted Answer

To make queries run faster

Answer

To keep the data in the database safe

Answer

To store extra information about a table

Answer

To connect records from different tables together

Question 38

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

Accepted Answer

Having lots of the same data

Answer

Sharing data

Answer

Keeping data safe

Answer

Keeping data consistent

Question 39

How are flat-file databases different from relational databases?

Accepted Answer

Flat-file databases store data in just one table, while relational databases use multiple tables.

Answer

Relational databases store data in just one table, while flat-file databases use multiple tables.

Answer

Flat-file databases and relational databases store data in exactly the same way.

Answer

Relational databases are more complicated than flat-file databases.

Question 40

Which SQL query would find all students in either Year 5 or Year 6?

Accepted Answer

SELECT * FROM Students WHERE Year = 5 OR Year = 6

Answer

SELECT * FROM Students WHERE Year = 5 AND Year = 6

Answer

SELECT * FROM Students WHERE Year = 5

Answer

SELECT * FROM Students WHERE Year = 6

Question 41

What is the main benefit of using an index in a database table?

Accepted Answer

Faster data retrieval

Answer

Increased data security

Answer

Reduced database size

Answer

Prevention of data duplication

Question 42

Why do we use constraints in a database?

Accepted Answer

To stop incorrect data being entered.

Answer

To make the database faster.

Answer

To connect different tables.

Answer

To put the data in a specific order.

Question 43

What's the primary purpose of a primary key in a database?

Accepted Answer

To ensure that each row in a table is unique

Answer

To store the most important data in a table

Answer

To link different tables together

Question 44

Why do we use foreign keys in database tables?

Accepted Answer

To link data between different tables

Answer

To give each record a unique number

Answer

To add extra information to each record

Question 45

What is a database?

Accepted Answer

A collection of organized data.

Answer

A type of computer program.

Answer

A place to store files.

Answer

A way to connect to the internet.

Question 46

Which of these is NOT a type of data field?

Accepted Answer

Picture

Answer

Text

Answer

Number

Answer

Boolean

Question 47

What is the purpose of a primary key?

Accepted Answer

To identify each record in a table uniquely.

Answer

To store the most important data in a table.

Answer

To connect two tables together.

Answer

To sort the data in a table.

Question 48

Which of the following SQL queries would get all the records from a table named 'Students'?

Accepted Answer

SELECT * FROM Students

Answer

SELECT ALL * FROM Students

Answer

GET * FROM Students

Answer

SHOW Students

Question 49

You want to keep track of information about your favorite animals. Which of these is the best tool to use?

Accepted Answer

A database

Answer

A word processor

Answer

A spreadsheet

Answer

A drawing program

Question 50

You want to find all the dogs in a database of pets. How would you do that?

Accepted Answer

Search the database for 'Type' and enter 'Dog'.

Answer

Sort the database alphabetically by 'Name'.

Answer

Add a new record for 'Dog' to the database.

Question 51

You have a database of your favorite books. You want to add a new book. What should you do?

Accepted Answer

Create a new record with information about the new book.

Answer

Change the database name to include the new book.

Answer

Delete an old record to make space for the new book.

Question 52

Which of these is NOT a good use for a database?

Accepted Answer

Drawing a picture of a cat.

Answer

Keeping track of books you borrow from the library.

Answer

Organizing a collection of stamps.

Question 53

You want to know how many students are in your class. What would be the best way to find out?

Accepted Answer

Use a database to count the number of records in the class list.

Answer

Guess how many students there are.

Answer

Ask each student to raise their hand and count them.

Question 54

What is a database similar to?

Accepted Answer

An organized filing cabinet

Answer

A blank sheet of paper

Answer

A messy desk

Question 55

What do we call a specific piece of information within a record in a database, like someone's name?

Accepted Answer

A field

Answer

A record

Answer

A query

Question 56

You have a database of your favorite animals. You want to sort them by size. How can you do this?

Accepted Answer

Sort the database by 'Size' from smallest to largest.

Answer

Add a new record for 'Size' to the database.

Answer

Search the database by 'Name' and find the smallest animal.

Question 57

In a database, what do we call a question we ask the database to find information?

Accepted Answer

A query

Answer

A field

Answer

A record