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.