Circle T if the statement is true or F if the statement is false. A transaction

Question

Circle T if the statement is true or F if the statement is false. A transaction file is used to indicate which records are to be updated in a file. During sequential file maintenance, the file to be updated is referred to as the master file. A new transaction file is created as output during file maintenance activities. File matching involves matching records in the transaction file to corresponding records in the master file. File matching logic require a transaction file and a master file to be in the same sequence by a key field. File maintenance cannot be performed on a sequential master file. Unmatched transactions must be written to the new master file. File matching requires that key fields from the master file and transaction file be compared. A master file record that is not updated is not written to the new master file. A posted transaction is the same as an unmatched master record. Unmatched masters always should be noted on an output report. Unmatched transaction records correspond to and are the same as unmatched master records. A duplicate transaction is a special type of unmatched transaction record. Use of the figurative constant, HIGH-VALUES, can eliminate the need for switches. Multiple update of the same master record are never allowed. An add transaction provide, data for the creation of a new master record. A change transaction provide, data for the deletion of a master record. The balance line algorithm may he used as a guide for developing the logic for the maintenance of a sequential file. An add transaction cannot be processed if a record with the specified key is already on the master file. File matching should be terminated when end of file is reached in the transaction file, or master file, whichever occurs first.

Explanation / Answer

1. True

2. True: Information that is kept on files needs to be modified as changes to the information on the file occur. This process is called UPDATING and the files that are being update are usually called MASTER FILES. Updating allows the company to keep a file up-to-date, without that capacity, the file would be obsolete shortly after it was created.

3. False

4. True

5. True :If both files are ordered on the key field, then this record matching operation functions correctly, but if either the transaction or the master file is unordered, record matching cannot work.A key field, is a field in the record whose value is unique to that record. For instance, in a student record, the StudentId is normally used as the key field. Without a key field to identify the record we require, we cannot delete or update records.

6. False

7. False, It can be written to any output file.

8. True

9. True

10. False

Posted transactions are ones where the requester does not expect to and will not receive a completion Transaction Layer Packet (TLP). If the write completer encounters an error, the requester will not know about it. But, it is possible for the write completer to generate an error message notification to the Root Complex.

11. True.

12. False

13. False

14. True

15. False

16. True

17. False

18. True: The balanced line algorithm is viewed by many as the most efficient and effective sequential file update method.

19. True :A key field, is a field in the record whose value is unique to that record.

20. True

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.