chap 13

______ file can be accessed randomly

• A sequential

• An indexed

• A hashed

• Any

______ file can be accessed sequentially

• A sequential

• An indexed

• A hashed

• No

When a sequential file is updated, the ______ file gets the actual update

• new master

• old master

• transaction

• error repor

When a sequential file is updated, the ______ file contains a list of all errors occurring during the update process

• new master

• old master

• transaction

• error report

When a sequential file is updated, the ______ file contains the changes to be applied.

• new master

• old master

• transaction

• error report

After a sequential file is updated, the _______ file contains the most current data

• new master

• old master

• transaction

• error report

If the transaction file key is 20 and the first master file key is 25, then we ______

• add the new record to the new master file

• revise the contents of the old master file

• delete the data

• write the old master file record to the new master file

If the transaction file key is 20 with a delete code and the master file key is 20, then we _______

• add the transaction to the new master file

• revise the contents of the old master file

• delete the data

• write the old master file record to the new master file

An indexed file consists of _______

• only a sequential data file

• only an index

• only a random data file

• an index and random data file

The index of an indexed file has _______ fields

• two

• three

• four

• any number of