Databases

Question 1

A persistent, organised store of data in electronic form

Answer 1

Database

Question 2

Database

Answer 2

A persistent, organised store of data in electronic form

Question 3

Software application that handles the data directly and provides an interface to the database

Answer 3

DBMS

Question 4

DBMS

Answer 4

Software application that handles the data directly and provides an interface to the database

Question 5

Type of database which contains only one table

Answer 5

Flat File

Question 6

Flat File

Answer 6

Type of database which contains only one table

Question 7

Type of database in which two or more tables are linked to each other

Answer 7

Relational

Question 8

Relational

Answer 8

Type of database in which two or more tables are linked to each other

Question 9

A set of data elements organised in fields and records

Answer 9

Table

Question 10

Table

Answer 10

A set of data elements organised in fields and records

Question 11

An object or thing of importance about which data is captured

Answer 11

Entity

Question 12

Entity

Answer 12

An object or thing of importance about which data is captured

Question 13

User interface tool which allows a user to enter or change data in a table

Answer 13

Form

Question 14

Form

Answer 14

User interface tool which allows a user to enter or change data in a table

Question 15

Database management tool used to retrieve information based on specified criteria

Answer 15

Query

Question 16

Query

Answer 16

Database management tool used to retrieve information based on specified criteria

Question 17

Database management tool used to present information to the user

Answer 17

Report

Question 18

Report

Answer 18

Database management tool used to present information to the user

Question 19

A field in a table which uniquely identifies each record in that table

Answer 19

Primary Key

Question 20

Primary Key

Answer 20

A field in a table which uniquely identifies each record in that table

Question 21

A field used in one table to represent the value of a primary key in a related table

Answer 21

Foreign Key

Question 22

Foreign Key

Answer 22

A field used in one table to represent the value of a primary key in a related table

Question 23

Name given to the undesirable effect of having duplicate data in a database

Answer 23

Redundancy

Question 24

Redundancy

Answer 24

Name given to the undesirable effect of having duplicate data in a database

Question 25

The automatic checking of inputted data by a computer system to ensure it is sensible

Answer 25

Validation

Question 26

Validation

Answer 26

The automatic checking of inputted data by a computer system to ensure it is sensible

Question 27

All data about one item in a database

Answer 27

Record

Question 28

Record

Answer 28

All data about one item in a database

Question 29

A property of something stored in a database

Answer 29

Field

Question 30

Field

Answer 30

A property of something stored in a database

Question 31

The process of ensuring that data entered into a database is correct

Answer 31

Verification

Question 32

Verification

Answer 32

The process of ensuring that data entered into a database is correct

Question 33

A database file where Items are stored as a series, one after another

Answer 33

Serial File

Question 34

Serial File

Answer 34

A database file where Items are stored as a series, one after another

Question 35

Set of rules that guarantee that database transactions are processed reliably

Answer 35

ACID

Question 36

ACID

Answer 36

Set of rules that guarantee that database transactions are processed reliably

Question 37

A database file where a series of items is stored in a logical order

Answer 37

Sequential File

Question 38

Sequential File

Answer 38

A database file where a series of items is stored in a logical order