Fun Learning and Revision for KS1, KS2, 11-Plus, KS3 and GCSE
Join Us
Data Storage 02
Losing data is no fun!

Data Storage 02

This is our second KS3 ICT quiz on data storage. Computer data storage provides one of the core functions of the modern computer, that of keeping valuable information safely and accurately. Each time data is transferred, it is possible that it may be changed slightly due to defects in the system. We say that data altered in this way has been corrupted. When saving any data, it is always good to have a separate back-up copy. This could be on an external hard drive, USB flash memory or something like a CD-ROM.

Data storage is normally organised into records and fields in a database, text files or images. The simplest database is known as a flat file. This is a file in which the data is stored in one single table. More complex databases contain data in different tables and are called relational databases. These are very useful where one item can have several different pieces of data stored about it e.g. the different books borrowed from a library by one person.

Did you know...

You can play all the teacher-written quizzes on our site for just £9.95 per month. Click the button to sign up or read more.

Sign up here
Data can be very valuable so needs storing on .......
flash drives
hard discs
any of the above
Whatever seems most suitable in the circumstances
Which of these is not a good way of protecting data?
Storing it on a CD-ROM and copying to magnetic tape
Storing it on one flash drive and copying to a second
Storing it on a hard disc alone
Storing it on a hard disc and copying to a flash drive
Not making a second copy of valuable data is a serious error
Which is not an accidental loss of data?
Loss caused by a hard disk drive failing
Loss caused by an attack by a computer virus
Loss caused by an unintentional deletion
Loss caused by fire damage
Viruses are deliberate attacks
People illegally viewing or changing computer systems .......
are called hackers
are called hawkers
are called hikers
work for MI5
There are various reasons why hackers break into computer systems - it is often done as part of a criminal activity
What is meant by a 'flat file' database?
It is a database split into several separate data files
It is a database using a single table for all records
It is a database without any records
It is a relational database which has been squashed
Often saved as a CSV (comma separated variable) text file
Which is most suitable for use as a flat file database?
Graphics editor
Web browser
Word processor
Flat file databases are best used where the amount of data is not too large
A spreadsheet can be used as a flat file database if .......
all the fields of one record occupy one spreadsheet row
each field is no more than 128 characters long
it doesn't contain any other text or formulae
no more than 10,000 records will be stored
In a relational database, the fields of one record can be spread between several tables
Queries allow you to ....... in a database.
select and update fields
select, filter and update fields
select, sort and filter fields
sort, filter and update fields
Updating records might be done using a 'form'
Printed output from a database is called a .......
It can be easier to read printed data than looking directly at the database fields
Making copies of data in case of a data loss is called .......
getting your back up
making a back-up
making a stuff up
putting your feet up
Frequently changing stored data needs frequent back-ups. The longer that you leave it between back-ups, the more data you could lose if you had a disaster like the computer breaking down
Author:  Duncan Daish

© Copyright 2016-2018 - Education Quizzes
TJS - Web Design Lincolnshire

Valid HTML5

We use cookies to make your experience of our website better.

To comply with the new e-Privacy directive, we need to ask for your consent - I agree - No thanks - Find out more