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.

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

Expansion for MVS

  1. McFunSoft Video Solution
  2. Multiple Video System
  3. Multiple Virtual Storage
  4. Multiple Virtual Subsystem
Question 2 Multiple Choice (Single Answer)

Expansion for CICS

  1. Customer Information Control System
  2. Control Information Customer System
  3. Control Index Cache System
  4. Control Index Cache Subsystem
Question 3 Multiple Choice (Single Answer)

DEFINE DATALOCAL01 #A (N2)END-DEFINERESET #AREPEAT UNTIL #A > 99 ADD 1 TO #AEND-REPEATENDWhat is the output of the above program?

  1. Displays from 1 to 99 and program ends normally
  2. displays from 1 to 100 and program ends normally
  3. Program will terminate abnormally without displaying anything
  4. displays till 99 and program will terminate abnormally
Question 4 Multiple Choice (Single Answer)

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?

  1. Read Statement
  2. Find Statement
  3. Histogram Statement
  4. Get Statement
Question 5 Multiple Choice (Multiple Answers)

What should be CA size for below specification of primary and secondary space allocation?

  1. 1 cylinder
  2. 5 cylinder
  3. 10 cylinder
  4. 50 cylinder
Question 6 True/False

Examine statement can be used to convert the lowercase to uppercase and vice versa

  1. True
  2. False
Question 7 Multiple Choice (Multiple Answers)

Calculate the number of Sequence set records and index set records for below VSAM file.

  1. Sequence Set = 3, Index Set = 1
  2. Sequence Set = 3, Index Set = 3
  3. Sequence Set = 2, Index Set = 1
  4. Sequence Set = 2, Index Set = 3
Question 8 Multiple Choice (Multiple Answers)

Calculate the embedded space in CA's for above VSAM file -

  1. 8965632
  2. 318689280
  3. 401231439
  4. No embedded space
Question 9 Multiple Choice (Multiple Answers)

Which of the following conditions suggest REORG of a VSAM file?

  1. compressed index key present in the INDEX record
  2. Average index key length is grater than 8
  3. High Embedded Freespace
  4. Extended upto 3 extent
  5. Low HIARBA
Question 10 True/False

Regular REORG is a Tunning procedure which improves VSAM performance.

  1. True
  2. False
Question 11 Multiple Choice (Single Answer)

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?

  1. No records will be displayed
  2. 5
  3. 4
  4. 3
Question 12 Multiple Choice (Single Answer)

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?

  1. #A: 123KDBEBDABFBBB #POS: 4
  2. #A: 123KDBEBDABFBBB #POS: 7
  3. #A: 123KDKEKDAKFKKK #POS: 7
  4. #A: 123KDKEKDAKFKKK #POS: 4
Question 13 Multiple Choice (Single Answer)

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?

  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 show any records
Question 14 Multiple Choice (Single Answer)

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?

  1. 123
  2. 123BD
  3. No Numeric Data
  4. Job will terminate abnormally
Question 15 Multiple Choice (Single Answer)

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
Question 16 True/False

Is it possible to read the adabas file in descending order of a descriptor?

  1. True
  2. False
Question 17 Multiple Choice (Single Answer)

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

  1. ABCSS012SS
  2. ABC012SSSS
  3. ABCSS12SSS
  4. ABC012
Question 18 Multiple Choice (Single Answer)

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?

  1. Record 1 & 5
  2. Record 3 & 5
  3. No output
  4. Record 1, 2, & 4
Question 19 Multiple Choice (Single Answer)

"Decide for" statement is used to check based on

  1. Natural Functions
  2. Conditions
  3. Values of a variable
  4. No such statement in Natural
Question 20 True/False

CALLNAT is used to call a main program.

  1. True
  2. False