Quiz
2.1.5 Databases
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (19)
1A database is a...
- Apersistent store of un-organised data.
- Bpersistent store of organised data.
- Cpersistent store of carefully selected and well organised data.
2Persistent storage is...
- Anon-volatile storage on a secondary storage medium such as a hard disk.
- Bvolatile storage on a secondary storage medium such as RAM.
- Cstorage on a secondary storage medium such as a hard disk.
3Data duplication (also known as data redundancy) is...
- Awhere the same data is stored more than once, unnecessarily.
- Bwhere the same data is stored only once, unnecessarily.
- Cwhere the same data is stored unnecessarily.
4Data inconsistency is...
- Awhere different versions of data become different because duplicate versions have been stored.
- Bwhere different versions of data become different because duplicate versions have been updated differently.
- Cwhere different versions of data become different because duplicate versions have been stored and updated differently.
5A Database Management System (DBMS)...
- Aseparates the applications from the data and provides features that allow database systems to be created,
interrogated and maintained. - Bseparates the applications from the data and provides features that allow database systems to be interrogated
and maintained. - Cseparates the applications from the data and provides features that allow database systems to be created and
maintained.
- Aseparates the applications from the data and provides features that allow database systems to be created,
6A flat file database is...
- Aa persistent organised store of data where data is stored in a single file organised into fields.
- Ba persistent organised store of data where data is stored in a single file organised into fields and records.
- Can organised store of data where data is stored in a single file organised into fields and records.
7A relational database is...
- Aa persistent organised store of data where data is stored as a collection of tables to minimise data redundancy.
- Ba persistent store of data where data is stored as a collection of related tables to minimise data redundancy.
- Ca persistent organised store of data where data is stored as a collection of related tables to minimise data
redundancy.
8An entity is a real world object, about which data is stored in a database and corresponds to...
- Aa table in a relational database.
- Ba field in a relational database.
- Ca primary key in a relational database.
9A table is a collection of data organised into records and fields within a relational database. A table represents a...
- Aforeign key
- Breal-world entity.
- Creport.
10Data stored about one instance of an entity, i.e. one particular person or object is called...
- Atable.
- Ba record.
- Ca field.
11One specific data item being stored such as a surname or shoe size is called...
- Aa primary key.
- Ba table.
- Ca field.
12A field in a table that uniquely identifies a record is called a...
- Aforeign key.
- Bprimary key.
- Centity key.
13A field in one table that is a primary key in another table and is used to create a relationship between those two tables is called...
- Aa primary key.
- Ba foreign key.
- Ca relationship key.
14A database form is...
- Aan interactive window used for data entry that doesn't include validation routines.
- Ban interactive window used for data entry that always includes validation routines.
- Can interactive window used for data entry that usually includes validation routines.
15When the computer software checks that data entered is sensible.
- AValidation
- BVerification
- CVerify
- DValidate
16Where data is entered twice and checked that each version is the same, to avoid data being entered with typing
mistakes.- AValidation
- BVerification
- CValidate
- DVerify
17Where data is entered twice and checked that each version is the same, to avoid data being entered with typing
mistakes.- AValidation
- BVerification
- CValidate
- DVerify
18A feature of a DBMS that allows the database to be interrogated. It selects records from the database based on
specified criteria.- AReport
- BQuery
- CSearch
19Data from a database that has been processed and presented on a page in a way that makes it information.
Designed for hard copy.- AReport
- BQuery
- CLetter
Information
- Description
- Database quiz OCR Computing
- Author
- Lavington ICT
- Language
- English
- Views
- 234
- History
- Created on 10 May 2015 · updated on 18 Jan 2017
- Tags
- Rating
- 4.0 out of 5 · 1 rating Rate this quiz