< >
Join now to discover more
or create your own Quizzes
Quiz
GoConqr is a social learning network with free tools, resources, courses and groups.
already a member? Log in

2.1.5 Databases

Question 1 of 19

Medal-premium 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.

Question 2 of 19

Medal-premium 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.

Question 3 of 19

Medal-premium 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.

Question 4 of 19

Medal-premium 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.

Question 5 of 19

Medal-premium 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.

Question 6 of 19

Medal-premium 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.

Question 7 of 19

Medal-premium 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.

Question 8 of 19

Medal-premium 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.

Question 9 of 19

Medal-premium 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.

Question 10 of 19

Medal-premium 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.

Question 11 of 19

Medal-premium 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.

Question 12 of 19

Medal-premium 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.

Question 13 of 19

Medal-premium 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.

Question 14 of 19

Medal-premium 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.

Question 15 of 19

Medal-premium 1

When the computer software checks that data entered is sensible.

Select one of the following:

  • Validation

  • Verification

  • Verify

  • Validate

Question 16 of 19

Medal-premium 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

Question 17 of 19

Medal-premium 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

Question 18 of 19

Medal-premium 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

Question 19 of 19

Medal-premium 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

Icon_fullscreen

2.1.5 Databases

Lavington ICT
Quiz by , created almost 2 years ago

Database quiz OCR Computing

Eye 94
Pin 4
Balloon-left 0
Tags
Lavington ICT
Created by Lavington ICT almost 2 years ago
Close