Mainframe Programming - Natural, VSAM, Adabas, CICS
Test your knowledge of mainframe programming including Natural language, Adabas database operations, VSAM file management, and CICS/MVS fundamentals.
Questions
Expansion for MVS
- McFunSoft Video Solution
- Multiple Video System
- Multiple Virtual Storage
- Multiple Virtual Subsystem
Expansion for CICS
- Customer Information Control System
- Control Information Customer System
- Control Index Cache System
- Control Index Cache Subsystem
DEFINE DATALOCAL01 #A (N2)END-DEFINERESET #AREPEAT UNTIL #A > 99 ADD 1 TO #AEND-REPEATENDWhat is the output of the above program?
- Displays from 1 to 99 and program ends normally
- displays from 1 to 100 and program ends normally
- Program will terminate abnormally without displaying anything
- displays till 99 and program will terminate abnormally
Requirement is to read all the distinct values of following fields from a table called 'IDENTIFICATION-TABLE'. Fields need to be extracted are 1) IDENT-ID 2) IDENT-NAME 3) IDENT-AGE Super to be used for this requirement is SUPER-ID-NAME-AGE (combination of above fields). Which statement will be used to read the data efficiently from IDENTIFICATION-TABLE?
- Read Statement
- Find Statement
- Histogram Statement
- Get Statement
What should be CA size for below specification of primary and secondary space allocation?
- 1 cylinder
- 5 cylinder
- 10 cylinder
- 50 cylinder
Examine statement can be used to convert the lowercase to uppercase and vice versa
- True
- False
Calculate the number of Sequence set records and index set records for below VSAM file.
- Sequence Set = 3, Index Set = 1
- Sequence Set = 3, Index Set = 3
- Sequence Set = 2, Index Set = 1
- Sequence Set = 2, Index Set = 3
Calculate the embedded space in CA's for above VSAM file -
- 8965632
- 318689280
- 401231439
- No embedded space
Which of the following conditions suggest REORG of a VSAM file?
- compressed index key present in the INDEX record
- Average index key length is grater than 8
- High Embedded Freespace
- Extended upto 3 extent
- Low HIARBA
Regular REORG is a Tunning procedure which improves VSAM performance.
- True
- False
Data in the database ------------------------------- IDENT-ID IDENT-NAME IDENT-AGE 1234 AAAA 12 1234 AAAA 12 3456 CCCC 14 6879 DDDD 17 7625 EEEE 21 HISTOGRAM IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' WRITE IDENT-ID IDENT-NAME IDENT-AGE END-HISTOGRAM How many records will be displayed in the output?
- No records will be displayed
- 5
- 4
- 3
DEFINE DATALOCAL01 #A (A15)01 #POS (N2)END-DEFINEMOVE '123BDBEBDABFBBB' TO #AEXAMINE #A FOR 'B' REPLACE FIRST 'K' GIVING POSITION #POS WRITE '=' #A '=' #POSENDWhat is the value of #A and #POS?
- #A: 123KDBEBDABFBBB #POS: 4
- #A: 123KDBEBDABFBBB #POS: 7
- #A: 123KDKEKDAKFKKK #POS: 7
- #A: 123KDKEKDAKFKKK #POS: 4
Data in the database-------------------------------IDENT-ID IDENT-NAME IDENT-AGE IDENT-SEX1234 AAAA 12 M1234 AAAA 12 F3456 CCCC 14 F6879 DDDD 17 M7625 EEEE 21 FHISTOGRAM IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' WRITE IDENT-ID IDENT-NAME IDENT-AGE IDENT-SEXEND-HISTOGRAMWhat will be the output of the job?
- 4 records will be displayed
- 5 records will be displayed
- Job will fail abnormally
- Job will run successfully but will not show any records
DEFINE DATA LOCAL 01 #A (A5) END-DEFINE MOVE '123BD' TO #A IF #A EQ MASK(NNN) WRITE '=' #A ELSE WRITE 'NO NUMERIC DATA' END-IF END What is the output of program?
- 123
- 123BD
- No Numeric Data
- Job will terminate abnormally
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?
- No records will be displayed
- 2nd to 5th record will be displayed
- 2nd record alone will be displayed
- All records will be displayed
Is it possible to read the adabas file in descending order of a descriptor?
- True
- False
DEFINE DATA LOCAL 01 #A (A5) 01 #B (A5) 01 #C (A10) END-DEFINE MOVE 'ABC' TO #A MOVE '012' TO #B COMPRESS #A #B INTO #C LEAVING NO SPACE WRITE #C END What is the value of #C? * S in answer stands for space
- ABCSS012SS
- ABC012SSSS
- ABCSS12SSS
- ABC012
IDENT-ID IDENT-NAME IDENT-AGE 1234 AAAA 12 2345 BBBB 23 3456 CCCC 14 6879 DDDD 17 7625 EEEE 21 READ IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE REJECT IF IDENT-AGE NE '21' AND IDENT-AGE NE '14' END-READ What will be the output of above program?
- Record 1 & 5
- Record 3 & 5
- No output
- Record 1, 2, & 4
"Decide for" statement is used to check based on
- Natural Functions
- Conditions
- Values of a variable
- No such statement in Natural
CALLNAT is used to call a main program.
- True
- False