NEW
Font size
WorksheetsKS2 Database Quiz
Total questions: 30
Worksheet time: 15mins
What is a primary key in a database?
A special password
A field that makes each record unique
A list of all fields
A type of number
Which of these would make the best primary key for a School Pupils table?
Favourite colour
Student ID number
Age
Height
Why is a primary key important?
To count records
To stop duplicate records
To make the table colourful
To store pictures
Can two records share the same primary key value?
Yes, always
Only on Fridays
No, each must be different
Only if it's a number
Which field could be a primary key in a library database?
Author name
Book title
Book ID code
Shelf colour
In a database table, a field is:
A big grassy area
A single piece of information, like 'Age'
A whole row of data
A password
A record is:
All the information about one person or item
Only a number
A picture in a cell
A field heading
If a table stores names and phone numbers, which is a field?
Phone number
Mary Jones
The whole table
The database software
Which shows a record correctly?
Age, Name, Phone
Lucy, 10, 0712345678
Integer, Boolean, Char
Table design
How are fields arranged in a table?
In columns
In random shapes
In paragraphs
In pictures
What does a query do in a database?
Prints the table
Searches for specific data
Deletes records
Creates a password
In a query, the symbol < means:
Greater than
Equal to
Less than
Not equal
The symbol > means:
Greater than
Less than
Equal to
Minus
The symbol = means:
Bigger
Smaller
Equal to
Add
If you run a query Age > 10, what will it show?
Everyone younger than 10
Everyone older than 10
Only age 10
Nobody
Which query finds pupils exactly aged 12?
Age < 12
Age > 12
Age = 12
Age ≠ 12
To find all books published before 2000, which operator fits?
=
>
<
>=
A query asking for Price > 20 will show:
Items costing more than 20
Items costing 20 or less
Items equal to 20
None of the above
To see pupils aged 8 or younger, which operator should be used?
>
=
< or =
> and =
If you need exactly the same value as stored, which symbol is correct?
<
>
≠
=
Which data type stores letters and numbers mixed together?
Integer
Boolean
Alphanumeric
Date
A whole number like 15 is which data type?
Integer
Char
Boolean
Alphanumeric
Which data type can only be True or False?
Date
Boolean
Integer
Char
A single character like 'A' is what data type?
Integer
Boolean
Char
Date
A birthday stored as 12/05/2012 is which data type?
Boolean
Alphanumeric
Date
Char
Which is an example of alphanumeric data?
456
House22
True
14/02/2025
Which of these is an integer?
Blue
67
6B
May 5th
Which of these is a boolean value?
Cat
False
101
Friday
The letter Z is best stored as:
Integer
Boolean
Char
Date
Which field would most likely use the Date type?
Student name
Date of birth
Age in years
True/False box
