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 control statement is used to indicate the utility that an editing operation is to be performed?

  1. GENERATE

  2. MODIFY

  3. ALTER

  4. MEMBER


Correct Option: A

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

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

  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

Must tape dataset definitions include VOL=SER specifications?

  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

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?

  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

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

  1. one

  2. two

  3. six

  4. four


Correct Option: A

DECLARE CURSOR is executable.

  1. True

  2. False


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

default of orderby is

  1. DSC

  2. ASC

  3. DSS

  4. ASS


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

A PL/I programmer wants to repeat an instruction 5 times. How can he/she code this?

  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
  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