Deck 20: Sequential File Updating

Question 1

12.An exception report from the sequential update program:

A)Lists all of the changed records in the master file.
B)Lists all of the errors found in updating the master file.
C)Lists all of the records in the transaction file.
D)Lists all of the records in the activity file.

Answer 1

B

Question 2

11.The transaction file:

A)Is listed in random order.
B)Is listed in order of the primary key of the master file.
C)Is listed in order of the first field of the master file.
D)None of the above.

Answer 2

B

Question 3

14.The transaction code:

A)Is used to find the correct record in the master file.
B)Indicates the type of update that is needed: adding a record,changing a record,or deleting a record.
C)Is used to create the exception report.
D)All of the above.

Answer 3

B

Question 4

13.When updating a sequential file:

A)The transaction primary key is compared to the new master primary key.
B)The activity primary key is compared to the old master primary key.
C)The transaction primary key is compared to the old master primary key.
D)None of the above.

Question 5

8.In order to update a file,it must be created first and have records added.

Question 6

5.To update a sequential file,each record must be read sequentially and check to see if it needs updating.

Question 7

6.Updating a file means to only add new records.

Question 8

7.A sequential file is updated through the use of interactive processing.

Question 9

9.A systems flowchart show the flow of data between hardware units and software.

Question 10

2.The master file holds all of the data to be updated.

Question 11

21.Updating a file uses a process called

A)Interactive processing.
B)Batch processing.
C)Alternative processing.
D)Change processing.

Question 12

4.Backup files are not important to keep.

Question 13

19.When questions about a record come about,the file that is most import to check is:

A)Transaction file.
B)Activity file.
C)Old master file.
D)Backup file.
E)None of the above.

Question 14

10.Records may be added,deleted,or changed during the processing of updating a file.

Question 15

18.Errors are written to the error report when:

A)The transaction file finishes before the master file.
B)The master file finishes before the transaction file.
C)A record is added that has a duplicate to an existing record.
D)All of the above.
E)None of the above.

Question 16

1.When adding a record to a sequential file,it is added to end of the file.

Question 17

20.After the completion processing of the program to update a sequential file,

A)The old master file is the same as the new master file.
B)The backup file is the same as the new master file.
C)The old master file is the same as the backup file.
D)None of the above.

Question 18

15.The backup file:

A)Is made from the old master file.
B)Is important to keep.
C)Does not include the updates to the master file.
D)All of the above.

Question 19

3.The activity file holds all of the data to update the master file.

Question 20

23.A record that is added to the file

A)Is placed at the end of the file.
B)Is placed in order.
C)Is placed at the beginning of the file.
D)None of the above.

Question 21

24.In the process of updating a file

A)The file is kept in order of the primary key.
B)The file order is destroyed.
C)The file is kept in order of the secondary key.
D)The file is kept in order of a foreign key.