Mainframe Systems: CICS, JCL, and DB2 Fundamentals

Test your knowledge of IBM mainframe technologies including CICS transaction processing, JCL job control, COBOL batch programming, and DB2 database operations.

16 Questions Published

Questions

Question 1 Multiple Choice (Multiple Answers)

Select query for a date field should be

  1. SELECT DATE(tablename.Date_variable, ISO)
  2. SELECT (tablename.Date_variable AS DATE)
  3. SELECT CHAR(CAST (tablename.Date_variable AS DATE), ISO)
  4. ALL OF THEM
Question 2 Multiple Choice (Multiple Answers)

For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp

  1. 0001-01-01 and 0000-00-00-00.00.00.000000
  2. 0001-01-01 and 0001-01-01-01.01.01.000001
  3. 0000-00-00 and 0000-00-00-00.00.00.000000
  4. 0001-01-01 and 0001-01-01-00.00.00.000000
Question 3 Multiple Choice (Multiple Answers)

The proc coded in all the last technical job in a JCL is:

  1. PMYPX074
  2. PMYPX075
  3. PMYPX076
  4. PMYPX077
Question 4 Multiple Choice (Multiple Answers)

What parameter is used for technical jobs that use DB2 check-point restart

  1. CKPTDB2
  2. CHKPNTDB2
  3. CKPT_DB2
  4. CHECKPOINTDB2
Question 5 Multiple Choice (Multiple Answers)

DD names for FB and VB input files are

  1. INPF,INPV
  2. INPFB,INPVB
  3. INFN,INVN
  4. none of the above
Question 6 Multiple Choice (Multiple Answers)

What is the JCL checker utility for error correction

  1. DIOJCLCK
  2. DIOAPLCK
  3. JCLUTLCK
  4. DIOAPLCHK
Question 7 Multiple Choice (Multiple Answers)

For calling the batch routines what is used

  1. XCTL
  2. CALL
  3. LINK
  4. none of the above
Question 8 Multiple Choice (Multiple Answers)

Incase of batch,While executing test cases where the output file needs to be mentioned

  1. Q01
  2. Q04
  3. PRD
  4. DEV
Question 9 Multiple Choice (Multiple Answers)

What is the only statement in the EXIT para

  1. 1000-EXIT
  2. EXIT
  3. 1000_EXIT
  4. BOTH a and b
Question 10 Multiple Choice (Multiple Answers)

After inclusion/deletion/modification of a technical job what needs to done

  1. Refresh OPC scheduleby TOP
  2. Build the modified components
  3. Both 1 and 2
  4. nothing needds to changed
Question 11 Multiple Choice (Multiple Answers)

Through which of the following the cics intercommunication can be achieved?

  1. MRO
  2. ISC
  3. ISO
  4. Neither MRO nor ISC
  5. ISA
  6. Both ISO and ISA
Question 12 True/False

In MRO, each of the CICS runs by depending on each other?

  1. True
  2. False
Question 13 True/False

CEBR is an CICS supplied temporary storage browse transaction?

  1. True
  2. False
Question 14 True/False

All cics transaction abends starts with A?

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

Within one processor there could be more than one CICS's each of which runs independently under the same OS. Such communication is called as ____?

  1. Multi Region Operation
  2. Inter System Communication
  3. Both the above
  4. None of the above
Question 16 Multiple Choice (Single Answer)

One CICS in one processor can communicate with other CICS in other processor or other non-cics systems regardless of where the other processor or non-cics systems are physically located. Such communication is called as _____?

  1. Multi Region Operation
  2. Inter System Communication
  3. Both the above
  4. None of the above