Tag: mainframe

Questions Related to mainframe

Data in IDENTIFICATION-TABLE IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAA 23 2345 ACDB 13 3456 ADSB 25 4567 DADS 15 5678 EDSC 20 READ IDENTIFICATION-TABLE BY SUPER-NAME-ID-AGE STARTING FROM 'A' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP How many number of records will be displayed in the output? * SUPER-NAME-ID-AGE comprises fields IDENT-NAME, IDENT-ID, & IDENT-AGE in the mentioned order.

  1. 3

  2. 4

  3. 5

  4. Program will terminate abnormally


Correct Option: C

Data in IDENTIFICATION-TABLE IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAA 23 2345 ACDB 13 3456 ADSB 25 4567 DADS 15 5678 EDSC 20 READ IDENTIFICATION-TABLE BY SUPER-NAME-ID-AGE STARTING FROM 'A' THRU 'D' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP WRITE IDENT-ID IDENT-NAME IDENT-AGE What is the value of final record displayed?

  1. 2345 ACDB 13

  2. 3456 ADSB 25

  3. 4567 DADS 15

  4. 5678 EDSC 20


Correct Option: D
  1. Required for effective use of DML statements

  2. Used to help define the schema

  3. Shows area relationships

  4. Identifies the set name


Correct Option: A,D