UKUK USUSIndiaIndia

Every Question Helps You Learn

Join Us
Streak
Leading Streak Today
Your Streak Today
Streak
Leading Streak Today
Your Streak Today
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.

1 .
Data can be very valuable so needs storing on .......
flash drives
hard discs
DVD or CD-ROM
any of the above
Whatever seems most suitable in the circumstances
2 .
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
3 .
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
4 .
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
5 .
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
6 .
Which is most suitable for use as a flat file database?
Graphics editor
Spreadsheet
Web browser
Word processor
Flat file databases are best used where the amount of data is not too large
7 .
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
8 .
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'
9 .
Printed output from a database is called a .......
result
response
report
retort
It can be easier to read printed data than looking directly at the database fields
10 .
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
You can find more about this topic by visiting BBC Bitesize - Data and databases

Author:  Duncan Daish

© Copyright 2016-2024 - Education Quizzes
Work Innovate Ltd - Design | Development | Marketing