Multiple choice technology mainframe

"Data in the database ------------------------------- IDENT-ID IDENT-NAME IDENT-AGE IDENT-SEX 1234 AAAA 12 M 1234 AAAA 12 F 3456 CCCC 14 F 6879 DDDD 17 M 7625 EEEE 21 F HISTOGRAM IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' WRITE IDENT-ID IDENT-NAME IDENT-AGE IDENT-SEX END-HISTOGRAM What will be the output of the job?"

  1. 4 records will be displayed

  2. 5 records will be displayed

  3. Job will fail abnormally

  4. Job will run successfully but will not display any records
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The HISTOGRAM statement will iterate over each UNIQUE value of the specified field. IDENT-ID 1234 appears twice with different IDENT-SEX values (M and F). Using IDENT-NAME in the SUPER clause would require it to be a descriptor field. Since the question has no explicit descriptors and the SUPER clause syntax with multiple fields is unusual, the job will likely fail. However, the primary failure reason is that HISTOGRAM with a non-descriptor field requires special handling that isn't shown.

Keep practicing — related questions