NEW
Font size
WorksheetsDatabase concepts worksheet questions
Total questions: 21
Worksheet time: 11mins
What makes you “information rich”?
Having a lot of money
Access to many different sources of information
Owning a powerful computer
Having fast broadband only
You are information poor if you don’t have much money.
True
False
Which of the following is an advantage of a computerised database?
It always works without electricity
It takes up more physical space than paper
It is quicker to search and easier to edit
It can only store one record at a time
What is a whole set of data in a database called?
Field
Record
File
Folder
What is a field in a database?
A complete collection of records
A separate heading of information inside a record
A backup copy of a database
A list of all the tables
Which data type is most suitable for storing a phone number?
Number
Currency
Text
Boolean
Which data type should be used for this information: 123.22, 453.22, 232.21 ?
Text
Number
Boolean
Date/Time
Which data type can store values such as TRUE or FALSE?
Text
Number
Boolean
Date/Time
Information is ______ data.
Raw
Processed
Binary
Coded
A database that stores all data in a single table is called a…
Flat file database
Multi-table database
Relational database
Hierarchical database
A database that stores data in more than one linked table is called a…
Flat file database
Single-file database
Multi-table (relational) database
Linear database
If this table is sorted in ascending order for the PET TYPE field, what would be the last name?
John Brown
Aisha Khan
Gillian Smith
Samir Patel
If this table is sorted in descending order for the PET NAME field, what would be the last PET TYPE?
Dog
Cat
Rabbit
Fish
What is another name for the PRIMARY KEY?
Main field
Key field
Master field
Link field
What is used to ask questions about a database and extract specific data?
Form
Query
Report
Macro
What do we call a field which is used to link tables together?
Link field
Join field
Foreign key
Secondary key
What type of search is this? Search on price field for > £150
Simple search
Complex search
Wildcard search
Pattern search
What is another way to describe sorting from Z to A?
Random
Alphabetical
Ascending
Descending
“46” on its own is an example of…
Data
Information
Knowledge
A query
‘Mr Cunningham is 46 and will soon be able to join Saga for the over 50s.’ This is an example of…
Data
Information
Knowledge
Validation
What is the name given to the process of restricting or checking that data entered is allowed?
Verification
Validation
Encryption
Formatting
