WorksheetsDatabases
Total questions: 12
Worksheet time: 9mins
Name
Class
Date
1.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
2.
A column in a database.
a)
Field
b)
Record
c)
Entity
d)
Validation
3.
A group of related records.
a)
Entity
b)
Validation
c)
Field
d)
Filter
4.
A rule to make sure that only reasonable and sensible data is entered.
a)
Filter
b)
Query
c)
Validation
d)
Verification
5.
Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
6.
A method of only displaying records in a table that match specific criteria...
a)
Filter
b)
Validation
c)
Sort
d)
Verification
7.
A method for checking data entered e.g. Proof Reading or Double Entry.
a)
Verification
b)
Filter
c)
Data Types
d)
Query
8.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
9.
A data type used for storing numbers with a fractional part e.g. 3.142
a)
Integer
b)
Boolean
c)
Real / Float
d)
String
10.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
11.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
12.
Which of these is not a type of validation?
a)
Proof Reading
b)
Range
c)
Limit
d)
Presence
100 %
