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
Questions
COND=(code,operator,stepname). What is the range of the code in this COND?
- 1 - 255
- 1 - 4095
- 1 - 9999
- 1 - 5000
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
- True
- False
All the parameters suffixed by "=" are keyword parameter. except:
- LABEL=
- PGM=
- PROC=
- SKIP=
while concatenating input files if the block size is different then largest should be coded fisrt
- True
- False
S822 abend
- End of Volume
- Requested Region not available
- Crossing the print limit in spool
- Authorisation issue
S80A/S804 abend
- Load module not found
- End of Volume
- Requested region is not enough
- Attenpting to divide by 0 and not using ON SIZE ERROR
If the Job runs more than the allowed time
- S222
- S822
- S322
- S122
S722 abend is for
- The data set name in the JCL did not match the data set name on the tape
- A module requested by the program could not be found.
- The storage needed to execute the program was not available.
- The maximum number or output lines has been exceeded
S0CA abend
- The result of an arithmetic operation was too large for the receiving field.
- An invalid divide was attempted.
- The quotient exceeded the allowed data field size.
- A JCL DD statement was either invalid or missing.
A numeric field contained non-numeric data.
- S0C2
- S0C7
- S0C4
- S0C1
The wait time limit was exceeded for a job or job step.
- S522
- S322
- S722
- S222
What is the significance of first two digits of External card number :
- Country code
- Check digits
- Card speciality
- AMEX code
Protocol which used to trasfer data to mainframe in SFT
- HTTPS
- Connect Direct
- FTPS
- AS2
Retention period of a file in SFT outbox
- 10
- 40
- 30
- 15
Which digits of 15 digit External CM no. are Cycle cut No & Replacement digit?
- 5 & 11 respectively
- 10 & 12 respectively
- 10 & 15 respectively
- None of the above.
What is the maximum no of SSAs allowed in a CALL statement
- 99
- 33
- No limit
- 15
SFT
- Can Load jobs to Jobtrac
- Cannot trigger a job in Mainframe
- Cannot Load jobs to Jobtrac but it can trigger the job
- both b & c
What is the RC-ACCT-TYPE code for Corporate Basic Cards
- 5
- 1
- 4
- 2
What is the Significance of PLASTIC COLOUR & ASSET ID in ARQF02
- Significe actual colour of the Card
- Dummy Parameters
- Drives only Card Art & Description at MYCA level.
- None of the above
Query to fetch first 10 rows in DB2
- FETCH 10 ROWS ONLY
- GET FIRST 10 ROWS
- SELECT FIRST 10 ROWS
- FETCH FIRST 10 ROWS ONLY