2.1.5 Databases

Descripción

Database quiz OCR Computing
Lavington ICT
Test por Lavington ICT, actualizado hace más de 1 año
Lavington ICT
Creado por Lavington ICT hace alrededor de 9 años
186
10

Resumen del Recurso

Pregunta 1

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

Pregunta 2

Pregunta
Persistent storage is...
Respuesta
  • 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.

Pregunta 3

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

Pregunta 4

Pregunta
Data inconsistency is...
Respuesta
  • 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.

Pregunta 5

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

Pregunta 6

Pregunta
A flat file database is...
Respuesta
  • 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.

Pregunta 7

Pregunta
A relational database is...
Respuesta
  • 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.

Pregunta 8

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

Pregunta 9

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

Pregunta 10

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

Pregunta 11

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

Pregunta 12

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

Pregunta 13

Pregunta
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...
Respuesta
  • a primary key.
  • a foreign key.
  • a relationship key.

Pregunta 14

Pregunta
A database form is...
Respuesta
  • 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.

Pregunta 15

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

Pregunta 16

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

Pregunta 17

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

Pregunta 18

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

Pregunta 19

Pregunta
Data from a database that has been processed and presented on a page in a way that makes it information. Designed for hard copy.
Respuesta
  • Report
  • Query
  • Letter
Mostrar resumen completo Ocultar resumen completo

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