Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database basics for key stage 3

Total questions: 38

Worksheet time: 26mins

Name
Class
Date
1.

What are databases mainly used for?

a)

To store archived data

b)

To store and organise data

c)

To analyse data

2.

Which of the following statements best defines the word 'database'?

a)

A database is a collection of data or information which is stored in a logical and structured way

b)

A database is a collection of statistics stored only for computers.

c)

A database does not collect data or information.

3.

Which of the following uses paper-based databases?

a)

Phonebook

b)

Smart Phone

c)

Computer

4.

Why would you create a primary key?

a)

To make each record in a database unique

b)

To make each field in a database unique

c)

To make each query in a database unique

5.

Select one 'school/student based' database term.

a)

Allergies

b)

Type of pet

c)

Social media accounts

6.

Which of the following defines the term 'field' in relation to databases?

a)

A field is all of the information about one person or one thing

b)

A field is the collection of all the database records on one topic or subject

c)

A field is one type or piece of information

7.

Select the computer-based database

a)

Phonebook

b)

Chalkboard

c)

Google search engine

8.
A sports club needs to store information about each member.  The individual information about each member is called a:
a)
Field
b)
File
c)
Table
d)
Record
9.
One of the members of the Sports Club has decided to resign.  What would the secretary do with the record for that member on the database?
a)
Amend the record
b)
Delete the field
c)
Delete the record
d)
Delete the file
10.
The Sports Club has had an Open Day and has gained a new member.  How will they add their details to the database?
a)
Add another field
b)
Amend a record
c)
Add a new record
d)
Delete a record
11.

The whole database is called:

a)

The file

b)

The field

c)

The record

d)

The table

12.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
13.
A gym has a database with all their members they want to include email addresses in the database, what will they do?
a)
Add a record
b)
Add a field
c)
Edit a record
d)
Delete a field
14.
The school wants to sort the data by staff Surname.  How will they sort it?
a)
Ascending order
b)
Descending order
15.

What is this following a definition of?

Stores data/information in an organised way

a)

Field

b)

Database

c)

Record

d)

File/Table

16.

The rows in a database are called:

a)

Records

b)

Fields

c)

Attribute

d)

Coloum

17.

The columns in a database are called:

a)

Records

b)

Fields

c)

Primary key

d)

Foreign key

18.
A database does NOT consist of .........
a)
field
b)
table
c)
character
d)
report
19.
In a database, Yes/No, Text and Date/Time are all examples of:
a)
data types
b)
data queries
c)
tabs you can select
d)
records in the data table
20.
A method of only displaying records in a table that match specific criteria...
a)
Filter
b)
Validation
c)
Sort
d)
Verification
21.

What is a primary key?

a)

A field

b)

A record

c)

Two fields

d)

A unique reference

22.
What software should we use to create a database?
Select the best answer.
a)
Excel
b)
Access
c)
OneNote
d)
Word
23.
Which of the following can you do with a database?
a)
Search
b)
Sort
c)
Do calculations
d)
All of these
24.
A ________ in a database is used to hold a single item of data, such as "pupilName".
a)
Table
b)
Record
c)
Cell
d)
Field
25.
A row of fields in a database is known as:
a)
A column
b)
A cell reference
c)
A record
d)
A table
26.
All of the records in a database create a
a)
Spreadsheet
b)
Table
c)
Column
d)
None of these
27.
We want to order the records in a database by pupil names from A-Z.
This is an example of sorting in _______ order.
a)
Ascending
b)
Descending
28.
A database is essential to all shopping websites.
a)
True
b)
False
29.
Putting cells into A-Z order is called?
a)
Sort Ascending
b)
Sort Descending
c)
Filter Ascending
d)
Filter Descending
30.
Which of these is not data?
a)
Words
b)
Numbers
c)
Shoes
d)
Dates
31.
 What data type is your name? 
a)
text
b)
number
c)
date
d)
time
32.
 What data type is your address? 
a)
text
b)
number
c)
date
d)
time
33.
 What data type is this? 
a)
text
b)
number
c)
date
d)
graphic
34.
 What data type is this? 
a)
text
b)
number
c)
date
d)
graphic
35.
 What data type is this? 
a)
text
b)
number
c)
date
d)
graphic
36.
 What data type is 543? 
a)
text
b)
boolean
c)
date
d)
number
37.
 What data type is 13:35? 
a)
text
b)
boolean
c)
date
d)
time
38.
What data type is 25th December 2017?
a)
number
b)
date
c)
graphic
d)
boolean

Similar Resources on Wayground

Computer History & Hardware

40 questions

Computer History & Hardware

quiz

Worksheet

•

9th - 12th Grade

C++ Programming

40 questions

C++ Programming

quiz

Worksheet

•

9th - 12th Grade

Ôn Tập Học Kì I Lớp 4

35 questions

Ôn Tập Học Kì I Lớp 4

quiz

Worksheet

•

4th Grade - University

Utilizarea computerului 9A

36 questions

Utilizarea computerului 9A

quiz

Worksheet

•

9th Grade

Soal Latihan Sumatif Tengah Semester Informatika

35 questions

Soal Latihan Sumatif Tengah Semester Informatika

quiz

Worksheet

•

7th Grade

TIK KELAS 7

35 questions

TIK KELAS 7

quiz

Worksheet

•

7th Grade

Tin 8 số 1

35 questions

Tin 8 số 1

quiz

Worksheet

•

8th Grade

REMIDI PAS KELAS 8

40 questions

REMIDI PAS KELAS 8

quiz

Worksheet

•

8th Grade