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


WRONG1. Using a SORT verb, files must be sorted in ascending order.         
O A. True
C B. False

See page 612
Level: easy



WRONG2. The results of sorting may be different when the computer uses ASCII or EBCDIC.
C A. True
O B. False

See page 613
Level: medium



WRONG3. The SORT verb is case sensitive.
C A. True
O B. False

See page 613
Level: medium



WRONG4. A SORT statement can include both INPUT and OUTPUT PROCEDURES.
C A. True
O B. False

See page 624
Level: medium



WRONG5. If a SORT contains an INPUT PROCEDURE, the input file must not be opened.
O A. True
C B. False

See page 617
Level: medium



WRONG6. A SELECT ... ASSIGN statement must be coded for the sort file.
C A. True
O B. False

See page 614
Level: easy



WRONG7. The USING option of the SORT statement will automatically write the sorted records onto the output file.
O A. True
C B. False

See page 616
Level: easy



WRONG8. The GIVING option of the SORT statement will automatically open and close the output file.
O A. True
C B. False

See page 621
Level: easy



WRONG9. The MERGE statement cannot have an INPUT PROCEDURE.

C A. True
O B. False

See page 627
Level: medium



WRONG10. The clause: WITH DUPLICATES IN ORDER is an example of FILO.
O A. True
C B. False

See page 614
Level: medium



WRONG11. The SORT file can be permanently stored on disk.
O A. True
C B. False

See page 614
Level: medium



WRONG12. A MERGE statement can have three input files.
C A. True
O B. False

See page 627
Level: easy



TEXT13. The merge file is defined in the FILE SEC within a(n) ________________________

YOUR ANSWER:

The suggested answer is SD


See page 627
Level: medium



TEXT14. The statement OPEN INPUT IN-FILE is needed in what PROCEDURE? ________

YOUR ANSWER:

The suggested answer is INPUT PROCEDURE


See page 617
Level: medium



TEXT15. In an INPUT PROCEDURE, the statement that writes a record to the sort-file is: ________________________________________________________________________

YOUR ANSWER:

The suggested answer is RELEASE SORT-REC


See page 617
Level: medium



TEXT16. In an OUTPUT PROCEDURE, the statement that reads records from the SORT files is: _____________________________________________________________________

YOUR ANSWER:

The suggested answer is RETURN SORT-FILE


See page 622
Level: medium



TEXT17. What PROCEDURE performs some processing of incoming records before they are sorted? _________________________________________________________________

YOUR ANSWER:

The suggested answer is An INPUT PROCEDURE


See page 616
Level: easy



TEXT18. What PROCEDURE performs some processing of incoming records after they are sorted? _________________________________________________________________

YOUR ANSWER:

The suggested answer is An OUTPUT PROCEDURE


See page 621
Level: easy



TEXT19. If a file is to be sorted by STORE-NO and within STORE-NO by DEPT-NO, both in ascending order, write the clause in the SORT statement to do this:
________________________________________________________________________

YOUR ANSWER:

The suggested answer is    ON ASCENDING KEY    STORE-NO
               DEPT-NO


See page 614
Level: easy



TEXT20. The USING clause is used in place of what PROCEDURE in the SORT statement? ________________________________________________________________________

YOUR ANSWER:

The suggested answer is INPUT


See page 616
Level: easy



TEXT21. The GIVING clause is used in place of what PROCEDURE in the SORT statement? ________________________________________________________________________

YOUR ANSWER:

The suggested answer is OUTPUT


See page 621
Level: easy



TEXT22. What is the input file in the following statement? ____________________________
   SORT SORT-FILE
      ASCENDING KEY IS DEPT-NO
      ASCENDING KEY IS EMPLOYEE-NAME
         USING DEPT-FILE
         GIVING MASTER-FILE

YOUR ANSWER:

The suggested answer is DEPT-FILE


See page 613
Level: easy



TEXT23. With what option of the SORT statement will the sort file automatically contain a copy of every record in the input file? ______________________________________

YOUR ANSWER:

The suggested answer is the USING option


See page 616
Level: medium



WRONG24. Which of the following is FALSE about an INPUT PROCEDURE?
O A. It may count input records.
C B. It may sort the records on the sort file.
O C. It may contain in-line performs.
O D. The input file must be opened.
O E. It may select fields to be placed on the sort file.

See pages 617, 618
Level: medium



WRONG25. Which of the following is FALSE about an OUTPUT PROCEDURE?
O A. It may validate data in the sort records.
O B. Records are written to the output file.
O C. It may select fields to be placed on the output file.
C D. It may sort the records on the sort file.
O E. It may contain in-line performs.

See page 622
Level: medium



Retake Test