Multiple choice technology web technology

Find the error in the following syntax MERGE FILE-NAME-1 ON ASCENDING KEY ACCOUNT-NO INPUT PROCEDURE IS TEST-ACCOUNT-PARA USING FILE-NAME-2 OUTPUT PROCEDURE IS IS WRITE-ACCOUNT-PARA GIVING FILE-NAME-3

  1. No error

  2. Input procedure not allowed

  3. only one file is given as input

  4. both b and c
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The correct answer is D (both b and c). The MERGE statement has two errors: (1) MERGE does not allow an INPUT PROCEDURE - unlike SORT, MERGE only works with already-sorted files, so input procedures are invalid; (2) MERGE requires at least two input files to merge together, but only FILE-NAME-2 is specified after USING. The correct syntax would be MERGE with multiple files and no input procedure.

Keep practicing — related questions