2.1.5 Databases

Lavington ICT
Quiz by Lavington ICT, updated more than 1 year ago
153
10
0

Description

Database quiz OCR Computing
Tags

Resource summary

Question 1

Question
A database is a...
Answer
  • persistent store of un-organised data.
  • persistent store of organised data.
  • persistent store of carefully selected and well organised data.

Question 2

Question
Persistent storage is...
Answer
  • 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

Question
Data duplication (also known as data redundancy) is...
Answer
  • 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

Question
Data inconsistency is...
Answer
  • 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

Question
A Database Management System (DBMS)...
Answer
  • 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

Question
A flat file database is...
Answer
  • 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

Question
A relational database is...
Answer
  • 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

Question
An entity is a real world object, about which data is stored in a database and corresponds to...
Answer
  • a table in a relational database.
  • a field in a relational database.
  • a primary key in a relational database.

Question 9

Question
A table is a collection of data organised into records and fields within a relational database. A table represents a...
Answer
  • foreign key
  • real-world entity.
  • report.

Question 10

Question
Data stored about one instance of an entity, i.e. one particular person or object is called...
Answer
  • table.
  • a record.
  • a field.

Question 11

Question
One specific data item being stored such as a surname or shoe size is called...
Answer
  • a primary key.
  • a table.
  • a field.

Question 12

Question
A field in a table that uniquely identifies a record is called a...
Answer
  • foreign key.
  • primary key.
  • entity key.

Question 13

Question
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...
Answer
  • a primary key.
  • a foreign key.
  • a relationship key.

Question 14

Question
A database form is...
Answer
  • 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

Question
When the computer software checks that data entered is sensible.
Answer
  • Validation
  • Verification
  • Verify
  • Validate

Question 16

Question
Where data is entered twice and checked that each version is the same, to avoid data being entered with typing mistakes.
Answer
  • Validation
  • Verification
  • Validate
  • Verify

Question 17

Question
Where data is entered twice and checked that each version is the same, to avoid data being entered with typing mistakes.
Answer
  • Validation
  • Verification
  • Validate
  • Verify

Question 18

Question
A feature of a DBMS that allows the database to be interrogated. It selects records from the database based on specified criteria.
Answer
  • Report
  • Query
  • Search

Question 19

Question
Data from a database that has been processed and presented on a page in a way that makes it information. Designed for hard copy.
Answer
  • Report
  • Query
  • Letter
Show full summary Hide full summary

Similar

GCSE Biology B2 (OCR)
Usman Rauf
C1 Quiz
Leah Firmstone
OCR Physics P2 revision cards
Alex Howard
B7 Quiz - The Skeleton, Movement and Exercise
Leah Firmstone
P2 Quiz
Leah Firmstone
GCSE Physics P7 (OCR) - Light, Telescopes, and Images
Josh Price
GCSE Physics P7 (OCR) - Astronomy
Josh Price
Voices and vocal techniques
Rosa Brookes
B7.1-3 - Peak Performance
franimal
GCSE Physics P7 (OCR) - Sun, and Stars
Josh Price
GCSE Physics P7 (OCR) - Mapping the Universe
Josh Price