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


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


3. The SORT verb is case sensitive.
A.True
B.False


4. A SORT statement can include both INPUT and OUTPUT PROCEDURES.
A.True
B.False


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


6. A SELECT ... ASSIGN statement must be coded for the sort file.
A.True
B.False


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


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


9. The MERGE statement cannot have an INPUT PROCEDURE.

A.True
B.False


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


11. The SORT file can be permanently stored on disk.
A.True
B.False


12. A MERGE statement can have three input files.
A.True
B.False


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

Answer:


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

Answer:


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

Answer:


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

Answer:


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

Answer:


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

Answer:


19. 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:
________________________________________________________________________

Answer:


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

Answer:


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

Answer:


22. 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

Answer:


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

Answer:


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


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



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.