1. For updating an indexed file, the transaction file must be in sequence.   
A.True
B.False


2. An indexed file can be created using an editor.   
A.True
B.False


3. Relative files can be processed both sequentially and randomly.
A.True
B.False


4. A record key should have a numeric value.
A.True
B.False


5. A key field not in sequence will cause the INVALID KEY clause of a WRITE statement to be used.
A.True
B.False


6. To update an indexed file, the file should be opened for input.
A.True
B.False


7. The following format of READ statement is used when reading from a disk randomly:
   READ filename INVALID KEY statement…
A.True
B.False


8. When creating an indexed file, the following format of WRITE statement is used:
   WRITE...NEXT RECORD ...
A.True
B.False


9. FILE STATUS is a clause of the OPEN statement.
A.True
B.False


10. The purpose of a DECLARATIVES segment is to handle error checking procedures.
A.True
B.False


11. To update a relative file, the file should be opened in I-O mode.
A.True
B.False


12. To begin sequential processing of an indexed file at a record location other than the first, use the BEGIN statement.
A.True
B.False


13. A relative key must be defined in the FILE SECTION.
A.True
B.False


14. Using an indexed file as an external table is faster processing than table processing.
A.True
B.False


15. In a multi-purpose update program, what field indicates which type of operation is to be done? ________________________________________________________________

Answer:


16. What are folding, digit extraction, square value truncation, and the division algorithm method examples of? _____________________________________________________

Answer:


17. DECLARATIVES is coded in which DIVISION? ____________________________

Answer:


18. A problem with using keys with alphanumeric values is _______________________

Answer:


19. The associated data-name of the FILE STATUS clause must have PIC ___________

Answer:


20. What type of access permits an indexed file to be accessed both randomly and sequentially in a single program? ____________________________________________

Answer:


21. The OPEN modes for an indexed file include all of the following:
________________________________________________________________________

Answer:


22. When is the index created for an indexed file?_______________________________

Answer:


23. A SELECT statement may have each of the following clauses EXCEPT
A.ORGANIZATION IS DYNAMIC
B.WITH DUPLICATES
C.ALTERNATE RECORD KEY IS PART-DESCRIPTION
D.RECORD KEY IS PART-ID
E.RECORD KEY IS PART-ID ACCESS MODE IS RANDOM


24. Each of the following is true about relative files EXCEPT:
A.Access mode can be dynamic.
B.A relative key may have duplicate values.
C.OPEN mode can be I-O.
D.This organization is best used when keys are nearly consecutive.
E.It is created with a fixed maximum number of records.


25. Each of the following is true about creating an indexed file EXCEPT:
A.It uses a WRITE ... INVALID KEY statement.
B.The SELECT statement contains: RECORD KEY IS key field-name.
C.It can be created interactively.
D.The SELECT statement contains: ACCESS IS RANDOM.
E.The indexed file is the output file.



This is the end of the test. When you have completed all the questions and reviewed your answers, press the button below to grade the test.