Answer to Question #211775 in Algorithms for Jaguar

Question

QUESTION 26

Which one of the following statements regarding updating of sequential files is FALSE?

1. If minor changes are needed the transaction file is not necessary.

2. The new master file always contains the most current updates.

3. The old master file is normally kept for referencing, even after the new master file has

 successfully been created.

4. The error report file is necessary to take corrective action after errors occurred during an 

 update process.

QUESTION 27

Consider the following 4 files involved in updating a sequential file:

A. The old master file.

B. The new master file.

C. The transaction file.

D. The error report file.

Which of the following options regarding files A to D is TRUE?

1. File C contains a record of each successful write operation to file B.

2. File A is deleted as soon as file B is closed after the update.

3. File A can be updated directly, which makes file B unnecessary.

4. File D is updated with all errors that occur during the update process.

Answer 1

Input Transaction file:

Transaction file containing the information to add new records to the file, change existing records, and delete records from the file.

new Master file:

Main or master file containing company records for a particular application.

Old master files:

New version of the main or master file containing all the old information that did not change or was not deleted, plus the added information and the changed information.

Output transaction error report:

Report of errors that could not be processed - this usually involves:

• records that were supposed to be changed but aren't there
• records that were supposed to be deleted but weren't there
• records that were supposed to be added but a record with the same id was already there

So, option (1) is false.

27>

From the explanation of 26, we can conclude that correct answer is option (4)