Multiple choice technology mainframe

Data in the database ------------------------------- IDENT-ID IDENT-NAME IDENT-AGE 1234 AAAA 12 2345 BBBB 23 3456 CCCC 14 6879 DDDD 17 7625 EEEE 21 HISTOGRAM IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1235' WRITE IDENT-ID IDENT-NAME IDENT-AGE END-HISTOGRAM What records will be displayed in the output?

  1. No records will be displayed

  2. 2nd to 5th record will be displayed

  3. 2nd record alone will be displayed

  4. All records will be displayed
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

HISTOGRAM with SUPER-ID-NAME-AGE starting from '1235' will display all records where the superdescriptor key is greater than or equal to '1235'. The first record (ID 1234) is excluded. Records 2-5 (IDs 2345, 3456, 6879, 7625) all have keys >= 1235, so they are displayed. Option B is correct.

Keep practicing — related questions