Mainframe Programming: JCL, DB2, COBOL, CICS, and VSAM
Test your knowledge of mainframe computing including JCL, DB2 database, COBOL programming, CICS transactions, REXX, VSAM data sets, and JES3 job management.
Questions
What is the Physical storage length of each of the following DB2 data types:DATE, TIME, TIMESTAMP.
- 6bytes, 4bytes, 13bytes
- 4bytes, 3bytes, 11bytes
- 4bytes, 3bytes, 10bytes
- 5bytes, 3bytes, 11bytes
what are the various locking levels available in DB2?
- Index, Page,Table
- Page, Table, Tablesapce
- Page,Index,Tablespace
- None of the above
what is the COBOL picture clause of the following DB2 data types:DATE, TIME, TIMESTAMP
- PIC X(8), PIC X(8), PIC X(26)
- PIC X(12), PIC X(8), PIC X(28)
- PIC X(10), PIC X(8), PIC X(26)
- None of the above
Where can program checkpoints be stored for use in a restart?
- SYSCHK DD statement
- CHCKPOINT DD statement
- CHKOUT DD statement
- CHECK or DD statement
Which DD parameters are required ?
- Dsname, SPACE, UNIT
- Dsname, SPACE, RECFM
- Dsname, DISP, DCB, SPACE
- All parameters & Keywords are optional
What statement can be used to send data to another MVS JES3 node ?
- CONNECT
- XMIT
- LINK
- TRANSMIT
What is the function of //CNTL statement ?
- Delimits the PROC control statements
- Identifies the control card library
- Marks the beginning of one or more program control statements
- None of the above
How can a JES3 operator command be entered through the jobstream?
- Through the OPERATOR statement
- Through the console statement
- Through the COMMAND statement
- Through the //** statement
In SMS datasets, what is the function of the DD MGMTCLAS keyword?
- Lookup a storage profile from the class library
- Specify a management class for a new dataset
- Alters the default storage profile for the dataset
- Begin a storage class definition block
What is the purpose of the DD KEYLEN parameter?
- Specify the length of a data set key in bytes
- Override the key length of an SMS defined VSAM dataset
- Override the key length specified in the dataset label
- All of the above
What is the maximum size of a 01 level item in COBOL II?
- 16667899
- 16777215
- 25879654
- 158742636
Can you call an OS VS COBOL pgm from a VS COBOL II pgm ?
- In non-CICS environment, it is possible
- In CICS, this is not possible
- Both of above
- None of above
What is the Physical storage length of each of the following DB2 data types:DATE, TIME, TIMESTAMP.
- 6bytes, 4bytes, 13bytes
- 4bytes, 3bytes, 11bytes
- 4bytes, 3bytes, 10bytes
- 5bytes, 3bytes, 11bytes
what are the various locking levels available in DB2?
- Index, Page,Table
- Page, Table, Tablesapce
- Page,Index,Tablespace
- None of the above
what is the COBOL picture clause of the following DB2 data types:DATE, TIME, TIMESTAMP
- PIC X(8), PIC X(8), PIC X(26)
- PIC X(12), PIC X(8), PIC X(28)
- PIC X(10), PIC X(8), PIC X(26)
- None of the above
Where can program checkpoints be stored for use in a restart?
- SYSCHK DD statement
- CHCKPOINT DD statement
- CHKOUT DD statement
- CHECK or DD statement
Which DD parameters are required ?
- Dsname, SPACE, UNIT
- Dsname, SPACE, RECFM
- Dsname, DISP, DCB, SPACE
- All parameters & Keywords are optional
While doing a mass delete using a generic key, how can you determine the number of records deleted? (CICS)
- By using the NUMREC(data-area) option with the generic key.
- By using the NUMB(data-area) option with the generic key.
- By using the NUMBER(data-area) option with the generic key.
- None of the above
What does the following code do? "EXECIO * DISKR INDD (STEM SRCLINE. FINIS"
- Read one record from INDD and store in in SRCLINE stack.
- Read all the records from INDD and store in in SRCLINE stack.
- Write one record from INDD and store in in SRCLINE stack.
- Write all the records from INDD and store in in SRCLINE stack.
EXIT will terminate and leave a REXX exec unconditionally and does it have the option to return a value?
- Always returns a value.
- Never returns a value.
- Returns when RC is coded
- I am skipping this!!