Have an account?
Skip to Content
Build your own quiz
Suggestions for you
20 questions
Show Answers
See Preview
- 1. Multiple Choice
Which of these are features of a flat-file database? A flat-file database:
(Tick all that apply)
Retrieves its data from the internet
Is a collection of organised data
Is a collection of tables that contain data
Can be used to search and sort a dataset
Is stored on a computer
- 2. Multiple Choice
Which of these are examples of database fields? (Tick all that apply)
1st
Age
Mr
Class
- 3. Multiple Choice
How many records can you see in this database?
6
30
5
15
- 4. Multiple Choice
Here is the table view of a database. We want to answer the question: ‘How long is the longest dinosaur?’ Which field would you use to answer it?
Name
Length
Diet
12
- 5. Multiple Choice
Which column has this data been sorted by?
Surname
Class
Boarded
Age
- 6. Multiple Choice
What would you search for to answer this question – ‘How many males under ten years old were on board the Titanic?’
Name and age
Gender and class
Gender or age
Gender and age
- 7. Multiple Choice
The Titanic picked up passengers from:
- Southampton
- Cherbourg
- Queenstown
- Belfast
What would you search for to answer this question – ‘Altogether, how many people boarded at the highlighted places?’
Boarded = Belfast or Boarded = Queenstown
Age = 10 and Boarded = Belfast
Boarded = Queenstown or Age = 10
Boarded = Queenstown and Boarded = Belfast
- 8. Multiple Choice
Which two fields have been used to create this graph?
Population and country name
Country name and area
Area and currency
Currency and population
- 9. Multiple Choice
Here are two views which we can see when using a database: ‘table view’ and ‘chart view’. If I wanted to know which two of the countries listed had the largest population, which view would be the most useful?
Table View
Chart View
- 10. Multiple Choice
What is a flat file database?
Contains a single table
Two or more linked tables
Used to create formula's
- 11. Multiple ChoiceWhich description is correct for a record?All the information about one person or itemUsed to print information from the databaseA method of searching the database for specific informationA place where all records are stored
- 12. Multiple ChoiceWhat is the main purpose of sorting/filtering data?Makes it nicer to look atMakes it easier to input new dataHelps to find specific information quicklyGives me something to do when I'm bored
- 13. Multiple Choice
A field is...
A specific item of data stored for each record
All the information about one object in the database
The whole database
- 14. Multiple ChoiceWhat would be the correct data type for the field 'Date of Birth'?Auto NumberDateTextDate/Time
- 15. Multiple ChoiceWhich data type would you apply to information stored about a company's finances (income and expenditure)?TextDate/TimeCurrencyNumber
- 16. Multiple ChoiceDatabases keep data in:TablesQueriesFormsReports
- 17. Multiple Choice
Who might use a database?
School
Police
Employer
All of the above
- 18. Multiple Choice
Short text, date, long text and number are all examples of what?
Data types
Headings
Fields
Records
- 19. Multiple Choice
What is an advanage of a database?
You can input information
Its different to Excel
It saves files
Can search through and find information quickly
- 20. Multiple Choice
Which of the following uses paper-based databases?
Phonebook
Smart Phone
Computer
- Answer choicesTagsAnswer choicesTags