2.1.5 Databases

Descrição

Database quiz OCR Computing
Lavington ICT
Quiz por Lavington ICT, atualizado more than 1 year ago
Lavington ICT
Criado por Lavington ICT aproximadamente 9 anos atrás
193
10

Resumo de Recurso

Questão 1

Questão
A database is a...
Responda
  • persistent store of un-organised data.
  • persistent store of organised data.
  • persistent store of carefully selected and well organised data.

Questão 2

Questão
Persistent storage is...
Responda
  • 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.

Questão 3

Questão
Data duplication (also known as data redundancy) is...
Responda
  • 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.

Questão 4

Questão
Data inconsistency is...
Responda
  • 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.

Questão 5

Questão
A Database Management System (DBMS)...
Responda
  • 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.

Questão 6

Questão
A flat file database is...
Responda
  • 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.

Questão 7

Questão
A relational database is...
Responda
  • 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.

Questão 8

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

Questão 9

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

Questão 10

Questão
Data stored about one instance of an entity, i.e. one particular person or object is called...
Responda
  • table.
  • a record.
  • a field.

Questão 11

Questão
One specific data item being stored such as a surname or shoe size is called...
Responda
  • a primary key.
  • a table.
  • a field.

Questão 12

Questão
A field in a table that uniquely identifies a record is called a...
Responda
  • foreign key.
  • primary key.
  • entity key.

Questão 13

Questão
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...
Responda
  • a primary key.
  • a foreign key.
  • a relationship key.

Questão 14

Questão
A database form is...
Responda
  • 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.

Questão 15

Questão
When the computer software checks that data entered is sensible.
Responda
  • Validation
  • Verification
  • Verify
  • Validate

Questão 16

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

Questão 17

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

Questão 18

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

Questão 19

Questão
Data from a database that has been processed and presented on a page in a way that makes it information. Designed for hard copy.
Responda
  • Report
  • Query
  • Letter

Semelhante

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