0% (0 out of 14 correct) |
|
![]() | 1. |
Using a SORT verb, files must be sorted in ascending order.
![]() Level: easy |
![]() | 2. |
The results of sorting may be different when the computer uses ASCII or EBCDIC.
![]() Level: medium |
![]() | 3. |
The SORT verb is case sensitive.
![]() Level: medium |
![]() | 4. |
A SORT statement can include both INPUT and OUTPUT PROCEDURES.
![]() Level: medium |
![]() | 5. |
If a SORT contains an INPUT PROCEDURE, the input file must not be opened.
![]() Level: medium |
![]() | 6. |
A SELECT ... ASSIGN statement must be coded for the sort file.
![]() Level: easy |
![]() | 7. |
The USING option of the SORT statement will automatically write the sorted records onto the output file.
![]() Level: easy |
![]() | 8. |
The GIVING option of the SORT statement will automatically open and close the output file.
![]() Level: easy |
![]() | 9. |
The MERGE statement cannot have an INPUT PROCEDURE.
![]() Level: medium |
![]() | 10. |
The clause: WITH DUPLICATES IN ORDER is an example of FILO.
![]() Level: medium |
![]() | 11. |
The SORT file can be permanently stored on disk.
![]() Level: medium |
![]() | 12. |
A MERGE statement can have three input files.
![]() Level: easy |
![]() | 13. | The merge file is defined in the FILE SEC within a(n) ________________________ YOUR ANSWER: ![]() See page 627 Level: medium |
![]() | 14. | The statement OPEN INPUT IN-FILE is needed in what PROCEDURE? ________ YOUR ANSWER: ![]() See page 617 Level: medium |
![]() | 15. |
In an INPUT PROCEDURE, the statement that writes a record to the
sort-file is:
________________________________________________________________________ YOUR ANSWER: ![]() See page 617 Level: medium |
![]() | 16. |
In an OUTPUT PROCEDURE, the statement that reads records from the SORT
files is:
_____________________________________________________________________ YOUR ANSWER: ![]() See page 622 Level: medium |
![]() | 17. |
What PROCEDURE performs some processing of incoming records before they
are sorted?
_________________________________________________________________ YOUR ANSWER: ![]() See page 616 Level: easy |
![]() | 18. |
What PROCEDURE performs some processing of incoming records after they
are sorted?
_________________________________________________________________ YOUR ANSWER: ![]() See page 621 Level: easy |
![]() | 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: ________________________________________________________________________ YOUR ANSWER: ![]() DEPT-NO See page 614 Level: easy |
![]() | 20. |
The USING clause is used in place of what PROCEDURE in the SORT
statement?
________________________________________________________________________ YOUR ANSWER: ![]() See page 616 Level: easy |
![]() | 21. |
The GIVING clause is used in place of what PROCEDURE in the SORT
statement?
________________________________________________________________________ YOUR ANSWER: ![]() See page 621 Level: easy |
![]() | 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 YOUR ANSWER: ![]() See page 613 Level: easy |
![]() | 23. |
With what option of the SORT statement will the sort file automatically
contain a copy of every record in the input file?
______________________________________ YOUR ANSWER: ![]() See page 616 Level: medium |
![]() | 24. |
Which of the following is FALSE about an INPUT PROCEDURE?
![]() Level: medium |
![]() | 25. |
Which of the following is FALSE about an OUTPUT PROCEDURE?
![]() Level: medium |