WorksheetsDatabases 1
Total questions: 16
Worksheet time: 8mins
Text/String, Integer, Real, Boolean and Date/Time are all examples of...
Data Types
Filters
Sorts
Validations
Integer
Boolean
Real
String
A data type that can only hold 2 values e.g. Yes/No.
Boolean
Integer
Real
String
What is a database?
A piece of software to do calculations
A device to load information onto the computer.
A structured collection of records
A calculator
What data type would be used to store the following item code: 0024
Text
Numeric
Calculated
Boolean
Which of the following is an example of a record?
347
ChannelType
351, Nature, Documentary, Bling, False
Choose all the reasons for storing data in a computer database:
data can be easily stored and retrieved
is saves paper and time
data can be quicly sorted
is less safe than storing data in a paper-based database
Select all data types that can be used in a database
date
alphanumeric
float
boolean
What type of field would be best to store the following text: "11-00-67"
Number
Currency
Date
Text
Reasons to code data in databases:
Speeding up data entry
Increase accuracy of data entry
Less storage space required
Coarsening of data
Hide the meaning of the data
