NEW
Font size
S
M
L
XL
WorksheetsDatabases
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
What is a database?
a)
A piece of software to do calculations
b)
A device to load information onto the computer.
c)
A structured collection of information
d)
A calculator
2.
Which of the following describes a relational database?
a)
Access
b)
A database that has a table
c)
There are two or more tables that are linked using the primary keys
d)
There are more than one table that have duplicate data
3.
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
4.
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
5.
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
6.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
7.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
8.
A scout company have a database with records of all the scouts. They want to create a list of all scouts who are under 15 and their achievements. What would they use?
a)
SQL UPDATE command
b)
Form
c)
SQL SELECT Query
d)
Sort
9.
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
10.
A health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' SQL query criteria?
a)
>3
b)
<3
c)
<=3
d)
>=3
11.
The health club stores the ages of its members. What validation check would be used on the age field?
a)
Restricted choice
b)
Length
c)
Presence
d)
Range
12.
What data type would be used to store the following item code: 0024
a)
Text
b)
Integer
c)
Real
d)
Boolean
13.
The school wants to sort the data by staff Surname. How will they sort it?
a)
Ascending order
b)
Descending order
14.
A film club stores details of all the films it shows. One of the fields is Genre (sample data: Action, Horror, Family, Romance etc). What validation would be most suitable for this field?
a)
Length
b)
Presence
c)
Range
d)
Restricted Choice
15.
IKEA stores details of it's stock on a relational database. Along with a unique stock code, all items are stored in coded aisles eg. BLU24, ORA23, YEL49 etc. What type of validation would be used on this aisle code?
a)
Presence
b)
Length
c)
Range
d)
Field
Reset
