Copy and Edit

2.1.5 Databases

Description

Database quiz OCR Computing
Lavington ICT
Quiz by Lavington ICT, updated more than 1 year ago
Lavington ICT
Created by Lavington ICT about 9 years ago
186
10
0

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

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

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