Lavington ICT
Quiz by , created more than 1 year ago

Database quiz OCR Computing

200
10
0
Lavington ICT
Created by Lavington ICT over 9 years ago
Close

2.1.5 Databases

Question 1 of 19

1

A database is a...

Select one of the following:

  • persistent store of un-organised data.

  • persistent store of organised data.

  • persistent store of carefully selected and well organised data.

Explanation

Question 2 of 19

1

Persistent storage is...

Select one of the following:

  • non-volatile storage on a secondary storage medium such as a hard disk.

  • volatile storage on a secondary storage medium such as RAM.

  • storage on a secondary storage medium such as a hard disk.

Explanation

Question 3 of 19

1

Data duplication (also known as data redundancy) is...

Select one of the following:

  • where the same data is stored more than once, unnecessarily.

  • where the same data is stored only once, unnecessarily.

  • where the same data is stored unnecessarily.

Explanation

Question 4 of 19

1

Data inconsistency is...

Select one of the following:

  • where different versions of data become different because duplicate versions have been stored.

  • where different versions of data become different because duplicate versions have been updated differently.

  • where different versions of data become different because duplicate versions have been stored and updated differently.

Explanation

Question 5 of 19

1

A Database Management System (DBMS)...

Select one of the following:

  • separates the applications from the data and provides features that allow database systems to be created,
    interrogated and maintained.

  • separates the applications from the data and provides features that allow database systems to be interrogated
    and maintained.

  • separates the applications from the data and provides features that allow database systems to be created and
    maintained.

Explanation

Question 6 of 19

1

A flat file database is...

Select one of the following:

  • a persistent organised store of data where data is stored in a single file organised into fields.

  • a persistent organised store of data where data is stored in a single file organised into fields and records.

  • an organised store of data where data is stored in a single file organised into fields and records.

Explanation

Question 7 of 19

1

A relational database is...

Select one of the following:

  • a persistent organised store of data where data is stored as a collection of tables to minimise data redundancy.

  • a persistent store of data where data is stored as a collection of related tables to minimise data redundancy.

  • a persistent organised store of data where data is stored as a collection of related tables to minimise data
    redundancy.

Explanation

Question 8 of 19

1

An entity is a real world object, about which data is stored in a database and corresponds to...

Select one of the following:

  • a table in a relational database.

  • a field in a relational database.

  • a primary key in a relational database.

Explanation

Question 9 of 19

1

A table is a collection of data organised into records and fields within a relational database. A table represents a...

Select one of the following:

  • foreign key

  • real-world entity.

  • report.

Explanation

Question 10 of 19

1

Data stored about one instance of an entity, i.e. one particular person or object is called...

Select one of the following:

  • table.

  • a record.

  • a field.

Explanation

Question 11 of 19

1

One specific data item being stored such as a surname or shoe size is called...

Select one of the following:

  • a primary key.

  • a table.

  • a field.

Explanation

Question 12 of 19

1

A field in a table that uniquely identifies a record is called a...

Select one of the following:

  • foreign key.

  • primary key.

  • entity key.

Explanation

Question 13 of 19

1

A 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...

Select one of the following:

  • a primary key.

  • a foreign key.

  • a relationship key.

Explanation

Question 14 of 19

1

A database form is...

Select one of the following:

  • an interactive window used for data entry that doesn't include validation routines.

  • an interactive window used for data entry that always includes validation routines.

  • an interactive window used for data entry that usually includes validation routines.

Explanation

Question 15 of 19

1

When the computer software checks that data entered is sensible.

Select one of the following:

  • Validation

  • Verification

  • Verify

  • Validate

Explanation

Question 16 of 19

1

Where data is entered twice and checked that each version is the same, to avoid data being entered with typing
mistakes.

Select one of the following:

  • Validation

  • Verification

  • Validate

  • Verify

Explanation

Question 17 of 19

1

Where data is entered twice and checked that each version is the same, to avoid data being entered with typing
mistakes.

Select one of the following:

  • Validation

  • Verification

  • Validate

  • Verify

Explanation

Question 18 of 19

1

A feature of a DBMS that allows the database to be interrogated. It selects records from the database based on
specified criteria.

Select one of the following:

  • Report

  • Query

  • Search

Explanation

Question 19 of 19

1

Data from a database that has been processed and presented on a page in a way that makes it information.
Designed for hard copy.

Select one of the following:

  • Report

  • Query

  • Letter

Explanation

Previous
Next