file organisation

Question 1

File

Answer 1

A collection of digital data stored as a single object on a disk

Question 2

Record

Answer 2

Collection of related data

Question 3

Fixed Length Field

Answer 3

Fields cannot change size, data is truncated or padded

Question 4

Pros Fixed Length Field

Answer 4

Pros - predictable size is easy, faster access able to directly access a byte

Question 5

Variable Length Field

Answer 5

Fields can change size to adapt to data

Question 6

Pros of Variable Length Field

Answer 6

Pro - Efficient with space

Question 7

Transaction File

Answer 7

Stores data over a short period of time

Question 8

Master File

Answer 8

Contains all the data made up of many iterations of the transaction file

Question 9

Serial

Answer 9

Records stored chronologically

Question 10

Sequential

Answer 10

A sequential file uses fixed length records access is from top to bottom file is sorted

Question 11

Indexed Sequential

Answer 11

Records are broken into groups, a separate index file is used to find where data is stored in the file.

Question 12

Direct Access

Answer 12

Allows immediate access of data using a hashing algorithm