Expand RCT

Expand JCT

Expand DCT

Data in IDENTIFICATION-TABLE IDENT-ID IDENT-NAME IDENT-AGE (Assume all fields are null suppressed) ----------------------------- 1234 AAAA 23 2345 bbbb 13 3456 ADSB 25 4567 DADS 15 5678 EDSC 20 READ IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP How many number of records will be displayed in the output? * small case bbbb stands for space

Assume an adabas database has been mapped with DDMS. viz IDENTIFICATION-TABLE & IDENTIFICATION-TABLE-EXP The difference between two DDMS is IDENTIFICATION-TABLE-EXP created with IDENT-NAME as (A6) whereas IDENTIFICATION-TABLE with (A4). A batch program is updating the database with IDENTIFICATION-TABLE-EXP. Values are as below. IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAAbb 23 2345 ACDBCD 13 3456 ADSBbb 25 4567 DADSbb 15 5678 EDSCbb 20 READ IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP How many records will be displayed in the output? * small case b stands for space

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?

Data in IDENTIFICATION-TABLE IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAA 23 1234 ABCD 22 2345 ACDB 13 3456 ADSB 25 4567 DADS 15 5678 EDSC 20 FIND IDENTIFICATION-TABLE WITH IDENT-ID EQ '1234' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP How many records will be displayed?

Data in IDENTIFICATION-TABLE IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAA 23 1234 ABCD 22 2345 ACDB 13 3456 ADSB 25 4567 DADS 15 5678 EDSC 20 FIND IDENTIFICATION-TABLE WITH IDENT-ID EQ '1234' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP The above FIND loop will end with two records. In which order, the records are displayed in the output?

Data in IDENTIFICATION-TABLE IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAA 23 2345 BBBB 13 3456 CCCC 25 4567 DDDD 15 5678 EEEE 20 READ IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1235' THRu '3457' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP How many number of records will be displayed in the output? * SUPER-ID-NAME-AGE comprises of all the above three fields in the mentioned order

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.

Data in IDENTIFICATION-TABLE IDENT-ID IDENT-NAME IDENT-AGE (Assume all fields are null suppressed)-----------------------------1234 AAAA 232345 bbbb 133456 ADSB 254567 DADS 155678 EDSC 20READ IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' DISPLAY IDENT-ID IDENT-NAME IDENT-AGELOOPHow many number of records will be displayed in the output?* bbbb stands for no value in that field

An ADABAS database can be mapped with more than one DDM

Assume an adabas database has been mapped with DDMS. viz IDENTIFICATION-TABLE & IDENTIFICATION-TABLE-EXP The difference between two DDMS is IDENTIFICATION-TABLE-EXP created with IDENT-NAME as (A6) whereas IDENTIFICATION-TABLE with (A4). A batch program is updating the database with IDENTIFICATION-TABLE-EXP. Values are as below. IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAAbb 23 2345 ACDBCD 13 3456 ADSBbb 25 4567 DADSbb 15 5678 EDSCbb 20 READ IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP How many records will be displayed in the output? * small letter b stands for space

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?