Logo

ICT Quiz - Data Storage 02 (Questions)

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
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
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
4. People illegally viewing or changing computer systems .......
[ ] are called hackers
[ ] are called hawkers
[ ] are called hikers
[ ] work for MI5
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
6. Which is most suitable for use as a flat file database?
[ ] Graphics editor
[ ] Spreadsheet
[ ] Web browser
[ ] Word processor
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
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
9. Printed output from a database is called a .......
[ ] result
[ ] response
[ ] report
[ ] retort
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

You can find more about this topic by visiting BBC Bitesize - Data and databases

Logo
ICT Quiz - Data Storage 02 (Answers)
1. Data can be very valuable so needs storing on .......
[ ] flash drives
[ ] hard discs
[ ] DVD or CD-ROM
[x] 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
[x] 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
[x] 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 .......
[x] 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
[x] 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
[x] 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 .......
[x] 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
[x] 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
[x] 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
[x] 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