Tag: mainframe

Questions Related to mainframe

Which control statement is used to indicate the utility that an editing operation is to be performed?
technology mainframe

  1. GENERATE

  2. MODIFY

  3. ALTER

  4. MEMBER

Show answer
Correct Option: A

Which is the utility that is used to convert data formats, rearrange input fields and change logical record length?
technology mainframe

  1. IEBDS

  2. IEHLIST

  3. IEHPROGM

  4. IEBGENER

Show answer
Correct Option: D

The datasets that are to be compared must satisfy which of the following conditions?

technology mainframe

  1. Both the datasets must have same block size

  2. Both the datasets must have same record length

  3. Both the datasets must have same block size and record length

  4. No condition is required

Show answer
Correct Option: B

Must tape dataset definitions include VOL=SER specifications?

technology mainframe

  1. Yes

  2. Only for Uncataloged datasets

  3. No

  4. Only for cataloged datasets

Show answer
Correct Option: B

Which control statement is used for reformatting the records that are sorted using SORT function?

technology mainframe

  1. SORTOUT

  2. OUTREC

  3. DFSORT

  4. AFTER

Show answer
Correct Option: B

If a(+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?

technology mainframe

  1. As the (0) generation

  2. As the (+1) generation

  3. As the (-1) generation

  4. Without generation number

Show answer
Correct Option: B

DECLARE TABLE in DCLGEN is necessary.

technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

environments which can access DB2
technology mainframe

  1. TSO

  2. CICS

  3. IMS

  4. BATCH

  5. ALL THE ABOVE

Show answer
Correct Option: E

What is sqlcode -922...?

technology mainframe

  1. SELECT statement has resulted in retrieval of more than one row

  2. AUTHORIZATION FAILURE

  3. consistency tokens in the DBRM and the load module are different

  4. NONE OF THE ABOVE

Show answer
Correct Option: B

How many clustering indexes can be defined for a table..?

technology mainframe

  1. one

  2. two

  3. six

  4. four

Show answer
Correct Option: A