0% (0 out of 17 correct)
The questions marked with symbol have not been graded.
Responses to questions are indicated by the symbol.


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

See page 648
Level: medium



WRONG2. An indexed file can be created using an editor.   
O A. True
C B. False

See page 647
Level: easy



WRONG3. Relative files can be processed both sequentially and randomly.
C A. True
O B. False

See page 640
Level: easy



WRONG4. A record key should have a numeric value.
C A. True
O B. False

See page 646
Level: medium



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

See page 646
Level: medium



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

See page 649
Level: easy



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

See page 649
Level: easy



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

See page 646
Level: easy



WRONG9. FILE STATUS is a clause of the OPEN statement.
O A. True
C B. False

See page 674
Level: easy



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

See page 676
Level: medium



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

See page 684
Level: easy



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

See page 666
Level: easy



WRONG13. A relative key must be defined in the FILE SECTION.
O A. True
C B. False

See page 680
Level: medium



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

See page 678
Level: medium



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

YOUR ANSWER:

The suggested answer is a coded field


See page 653
Level: medium



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

YOUR ANSWER:

The suggested answer is a randomizing or hashing algorithm used to convert numeric keys to relative record numbers


See pages 687, 690
Level: hard



TEXT17. DECLARATIVES is coded in which DIVISION? ____________________________

YOUR ANSWER:

The suggested answer is PROCEDURE


See page 676
Level: easy



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

YOUR ANSWER:

The suggested answer is extra blanks may be inserted, upper and lower case letters might be mixed, the use of commas may make table-look-ups difficult, different collating sequences cause records to be ordered differently


See page 646
Level: hard



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

YOUR ANSWER:

The suggested answer is X(2)


See page 674
Level: medium



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

YOUR ANSWER:

The suggested answer is dynamic


See page 668
Level: medium



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

YOUR ANSWER:

The suggested answer is INPUT, OUTPUT, I-O


See pages 647, 649
Level: easy



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

YOUR ANSWER:

The suggested answer is when the file is created


See page 643
Level: easy



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

See page 664
Level: medium



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

See pages 679, 680, 684
Level: medium



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

See pages 643, 644, 646, 647
Level: medium



Retake Test