2.1.5 Databases

Beschreibung

Database quiz OCR Computing
Lavington ICT
Quiz von Lavington ICT, aktualisiert more than 1 year ago
Lavington ICT
Erstellt von Lavington ICT vor etwa 9 Jahre
193
10

Zusammenfassung der Ressource

Frage 1

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

Frage 2

Frage
Persistent storage is...
Antworten
  • 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.

Frage 3

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

Frage 4

Frage
Data inconsistency is...
Antworten
  • 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.

Frage 5

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

Frage 6

Frage
A flat file database is...
Antworten
  • 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.

Frage 7

Frage
A relational database is...
Antworten
  • 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.

Frage 8

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

Frage 9

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

Frage 10

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

Frage 11

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

Frage 12

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

Frage 13

Frage
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...
Antworten
  • a primary key.
  • a foreign key.
  • a relationship key.

Frage 14

Frage
A database form is...
Antworten
  • 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.

Frage 15

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

Frage 16

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

Frage 17

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

Frage 18

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

Frage 19

Frage
Data from a database that has been processed and presented on a page in a way that makes it information. Designed for hard copy.
Antworten
  • Report
  • Query
  • Letter
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

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