0

mainframe Online Quiz - 24

Description: mainframe Online Quiz - 24
Number of Questions: 20
Created by:
Tags: mainframe
Attempted 0/20 Correct 0 Score 0

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

  1. IEBDS

  2. IEHLIST

  3. IEHPROGM

  4. IEBGENER


Correct Option: D
  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


Correct Option: B
  1. Yes

  2. Only for Uncataloged datasets

  3. No

  4. Only for cataloged datasets


Correct Option: B

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

  1. SORTOUT

  2. OUTREC

  3. DFSORT

  4. AFTER


Correct Option: B
  1. As the (0) generation

  2. As the (+1) generation

  3. As the (-1) generation

  4. Without generation number


Correct Option: B

DECLARE TABLE in DCLGEN is necessary.

  1. True

  2. False


Correct Option: B

environments which can access DB2

  1. TSO

  2. CICS

  3. IMS

  4. BATCH

  5. ALL THE ABOVE


Correct Option: E

What is sqlcode -922...?

  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


Correct Option: B

Count(*) ignores null

  1. True

  2. False


Correct Option: B

subqueries cannot have union

  1. True

  2. False


Correct Option: A

Sqlcode foreign key constraint is

  1. 531

  2. 530

  3. 513

  4. 533


Correct Option: B
  1. DSC

  2. ASC

  3. DSS

  4. ASS


Correct Option: B

Which of the following is not an isolation type

  1. RR

  2. CS

  3. RS

  4. SS


Correct Option: D

Which of the following statements about PL/I programs are TRUE? (2 answers)

  1. a program must always begin with a PROCEDURE statement and end with an END statement

  2. PL/I instructions can be coded between positions 1 and 72

  3. you have to declare each variable that you are going to use

  4. a program can be composed out of different procedures

  5. comment lines have to be preceded by //


Correct Option: A,D
  1. REPEAT 5 TIMES;instruction;END;

  2. DO J=1 TO 5;instruction;END;

  3. COUNTER = 1;DO WHILE COUNTER < 5;COUNTER = COUNTER + 1;instruction;END;

  4. REPEAT VARYING COUNTER FROM 1 BY 1 UNTIL COUNTER = 5;instruction;END;


Correct Option: B

Which of the following names of variables for data items are syntactically correct? (2 answers)

  1. READ

  2. RECORD-IN

  3. @_RECORD

  4. IN/OUTRECORD

  5. 1_TELEPHONE


Correct Option: A,C

Where in a PL/I program are you obliged to code a ; (semi colon) ? (3 answers)

  1. after each declaration of a variable

  2. at the end of each instruction

  3. to end a DO instruction

  4. at the end of the program

  5. to end an IF instruction


Correct Option: B,D,E
- Hide questions