0% (0 out of 17 correct) |
|
![]() | 1. |
For updating an indexed file, the transaction file must be in sequence.
![]() Level: medium |
![]() | 2. |
An indexed file can be created using an editor.
![]() Level: easy |
![]() | 3. |
Relative files can be processed both sequentially and randomly.
![]() Level: easy |
![]() | 4. |
A record key should have a numeric value.
![]() Level: medium |
![]() | 5. |
A key field not in sequence will cause the INVALID KEY clause of a WRITE statement to be used.
![]() Level: medium |
![]() | 6. |
To update an indexed file, the file should be opened for input.
![]() Level: easy |
![]() | 7. |
The following format of READ statement is used when reading from a disk randomly: READ filename INVALID KEY statement…
![]() Level: easy |
![]() | 8. |
When creating an indexed file, the following format of WRITE statement is used: WRITE...NEXT RECORD ...
![]() Level: easy |
![]() | 9. |
FILE STATUS is a clause of the OPEN statement.
![]() Level: easy |
![]() | 10. |
The purpose of a DECLARATIVES segment is to handle error checking procedures.
![]() Level: medium |
![]() | 11. |
To update a relative file, the file should be opened in I-O mode.
![]() Level: easy |
![]() | 12. |
To begin sequential processing of an indexed file at a record location other than the first, use the BEGIN statement.
![]() Level: easy |
![]() | 13. |
A relative key must be defined in the FILE SECTION.
![]() Level: medium |
![]() | 14. |
Using an indexed file as an external table is faster processing than table processing.
![]() Level: medium |
![]() | 15. |
In a multi-purpose update program, what field indicates which type of
operation is to be done?
________________________________________________________________ YOUR ANSWER: ![]() See page 653 Level: medium |
![]() | 16. |
What are folding, digit extraction, square value truncation, and the
division algorithm method examples of?
_____________________________________________________ YOUR ANSWER: ![]() See pages 687, 690 Level: hard |
![]() | 17. | DECLARATIVES is coded in which DIVISION? ____________________________ YOUR ANSWER: ![]() See page 676 Level: easy |
![]() | 18. | A problem with using keys with alphanumeric values is _______________________ YOUR ANSWER: ![]() See page 646 Level: hard |
![]() | 19. | The associated data-name of the FILE STATUS clause must have PIC ___________ YOUR ANSWER: ![]() See page 674 Level: medium |
![]() | 20. |
What type of access permits an indexed file to be accessed both
randomly and sequentially in a single program?
____________________________________________ YOUR ANSWER: ![]() See page 668 Level: medium |
![]() | 21. | The OPEN modes for an indexed file include all of the following: ________________________________________________________________________ YOUR ANSWER: ![]() See pages 647, 649 Level: easy |
![]() | 22. | When is the index created for an indexed file?_______________________________ YOUR ANSWER: ![]() See page 643 Level: easy |
![]() | 23. |
A SELECT statement may have each of the following clauses EXCEPT
![]() Level: medium |
![]() | 24. |
Each of the following is true about relative files EXCEPT:
![]() Level: medium |
![]() | 25. |
Each of the following is true about creating an indexed file EXCEPT:
![]() Level: medium |