Font size
WorksheetsN6 AIT - Benefits of Database Storage
Total questions: 20
Worksheet time: 11mins
What is the name given to a database which contains more than one table? (only one word answer required)
(a)
What is the name of the database software used in school?
Access
Abacus
Assess
Accent
What is the missing word - a database _____ is a collection of similar information stored in an organised way?
File
Folder
Footer
Field
What name is given to a collection of associated fields in a database?
Row
Table
Record
Query
How many records can you see in this database table?
7
8
9
10
How many field headers can you see in this database table?
7
8
9
10
What name is given to the process of rearranging database records in a certain order?
Saving
Searching
Sorting
Shaping
What name is given to the process of finding records in a database which meet certain conditions (criteria) e.g. find all girls who have blue eyes?
Sorting
Saving
Searching
Shaping
What data type was used to create the age field?
Text
Number
Currency
Date
What data type was used to create the surname field?
Text
Number
Currency
Date
A mobile phone company has been contacted by a customer who has moved house. What does the company need to do to the customers' record in the database?
Delete it
Save it
Sort it
Edit it
The mobile phone company has now been approached by a new customer who wants to take out a contract. What does the company need to do to the database?
Add the customer
Edit the customer
Save the customer
Delete the customer
Which field has been used to sort the database above?
Number
First Name
Age
Date
This database shows students who are going on a trip during Activities Week. The school office want to send out a separate list to each teacher organising a trip of just their students' details.
Which field will the office staff search by to create these lists?
Surname
Group
Gender
Medical Information
Which data type would be most suitable for the 'Salary' field in a table?
Currency
Date & Time
Number
Memo
How many fields and records (in that order) do you see in this database?
8 fields and 7 records
7 fields and 8 records
What name is given to this feature of a database?
Drop-down menu
Drop-in menu
Data check menu
Data type menu
What are the benefits of storing customer details in a database? More than one answer may be correct.
Customer details can be held on different tables which means access can be restricted
Using data types e.g. currency or data format will help increase errors
Security and confidentiality is improved which breaks GDPR requirements
More than one member of staff can access the database at the same time
What are the benefits of storing employee details in a database? More than one answer may be correct.
Drop-down menus will eliminate input errors by staff
Relational databases structure means that all staff should be able to edit salary levels
Searching, sorting, queries with criteria can all help find information quickly to improve decision making
Using fields means that different information is kept for all staff
What are the benefits of storing equipment details in a database? More than one answer may be correct.
It will ensure that GDPR isn't broken
Fewer errors if all data is in the same format
Only one member of staff can access the tables at the same time which increase the speed of access
Easier to add new equipment details and edit existing details than on paper
