Font size
S
M
L
XL
WorksheetsForm 4 Database CW
Total questions: 12
Worksheet time: 6mins
Name
Class
Date
1.
What data type is your name?
a)
text
b)
number
c)
date
d)
time
2.
What data type is 01776 706484?
a)
text
b)
boolean
c)
date
d)
time
3.
What data type is 543?
a)
text
b)
boolean
c)
date
d)
number
4.
What data type is 13:35?
a)
text
b)
boolean
c)
date
d)
time
5.
What data type is 31/5/2017?
a)
number
b)
date
c)
graphic
d)
boolean
6.
The following is a description of the data being held inside the database, what is the data type? The temperature in the room
a)
number
b)
date
c)
graphic
d)
boolean
7.
The following is a description of the data being held inside the database, what is the data type? A field that can have only 2 values.
a)
number
b)
date
c)
calculated
d)
yes/no
8.
The picture shows some features of a database. Which of the following are queries? (multiple answers allowed)
a)
teachRpt
b)
qryIT
c)
Teacher
d)
qryDegree
9.
What is the criteria for the query shown in the image
a)
Teacher
b)
No Degree
c)
No
d)
Yes Degree
10.
The image shows two database tables. Which of these queries below show fields that came from both tables? (You can have multiple answers)
a)
b)
c)
d)
11.
Which of the following is used to extract information from a database?
a)
tables
b)
queries
c)
relationships
d)
keys
12.
For the query shown in the image, what criteria was used to produce the result?
a)
no degree
b)
yes degree
c)
name
d)
females
Reset
