Mainframe Essentials: DB2, JCL, COBOL, and System Operations

Comprehensive quiz covering IBM mainframe topics including DB2 SQL queries, JCL (Job Control Language) parameters, COBOL programming, IMS database operations, mainframe abend codes, SFT (Secure File Transfer), and card management systems

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

COND=(code,operator,stepname). What is the range of the code in this COND?

  1. 1 - 255
  2. 1 - 4095
  3. 1 - 9999
  4. 1 - 5000
Question 2 True/False

if more than one sub-paramter or if there is any special character then enclose withing quotes/paranthesis. Max of 100 characters can be passed to cobol pgm including quotes/paranthesis

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

All the parameters suffixed by "=" are keyword parameter. except:

  1. LABEL=
  2. PGM=
  3. PROC=
  4. SKIP=
Question 4 True/False

while concatenating input files if the block size is different then largest should be coded fisrt

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

S822 abend

  1. End of Volume
  2. Requested Region not available
  3. Crossing the print limit in spool
  4. Authorisation issue
Question 6 Multiple Choice (Single Answer)

S80A/S804 abend

  1. Load module not found
  2. End of Volume
  3. Requested region is not enough
  4. Attenpting to divide by 0 and not using ON SIZE ERROR
Question 7 Multiple Choice (Single Answer)

If the Job runs more than the allowed time

  1. S222
  2. S822
  3. S322
  4. S122
Question 8 Multiple Choice (Single Answer)

S722 abend is for

  1. The data set name in the JCL did not match the data set name on the tape
  2. A module requested by the program could not be found.
  3. The storage needed to execute the program was not available.
  4. The maximum number or output lines has been exceeded
Question 9 Multiple Choice (Single Answer)

S0CA abend

  1. The result of an arithmetic operation was too large for the receiving field.
  2. An invalid divide was attempted.
  3. The quotient exceeded the allowed data field size.
  4. A JCL DD statement was either invalid or missing.
Question 10 Multiple Choice (Single Answer)

A numeric field contained non-numeric data.

  1. S0C2
  2. S0C7
  3. S0C4
  4. S0C1
Question 11 Multiple Choice (Single Answer)

The wait time limit was exceeded for a job or job step.

  1. S522
  2. S322
  3. S722
  4. S222
Question 12 Multiple Choice (Multiple Answers)

What is the significance of first two digits of External card number :

  1. Country code
  2. Check digits
  3. Card speciality
  4. AMEX code
Question 13 Multiple Choice (Single Answer)

Protocol which used to trasfer data to mainframe in SFT

  1. HTTPS
  2. Connect Direct
  3. FTPS
  4. AS2
Question 14 Multiple Choice (Single Answer)

Retention period of a file in SFT outbox

  1. 10
  2. 40
  3. 30
  4. 15
Question 15 Multiple Choice (Multiple Answers)

Which digits of 15 digit External CM no. are Cycle cut No & Replacement digit?

  1. 5 & 11 respectively
  2. 10 & 12 respectively
  3. 10 & 15 respectively
  4. None of the above.
Question 16 Multiple Choice (Multiple Answers)

What is the maximum no of SSAs allowed in a CALL statement

  1. 99
  2. 33
  3. No limit
  4. 15
Question 17 Multiple Choice (Multiple Answers)

SFT

  1. Can Load jobs to Jobtrac
  2. Cannot trigger a job in Mainframe
  3. Cannot Load jobs to Jobtrac but it can trigger the job
  4. both b & c
Question 18 Multiple Choice (Multiple Answers)

What is the RC-ACCT-TYPE code for Corporate Basic Cards

  1. 5
  2. 1
  3. 4
  4. 2
Question 19 Multiple Choice (Multiple Answers)

What is the Significance of PLASTIC COLOUR & ASSET ID in ARQF02

  1. Significe actual colour of the Card
  2. Dummy Parameters
  3. Drives only Card Art & Description at MYCA level.
  4. None of the above
Question 20 Multiple Choice (Single Answer)

Query to fetch first 10 rows in DB2

  1. FETCH 10 ROWS ONLY
  2. GET FIRST 10 ROWS
  3. SELECT FIRST 10 ROWS
  4. FETCH FIRST 10 ROWS ONLY