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

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
  1. Yes

  2. Only for Uncataloged datasets

  3. No

  4. Only for cataloged datasets


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

subqueries cannot have union

  1. True

  2. False


Correct Option: A
  1. DSC

  2. ASC

  3. DSS

  4. ASS


Correct Option: B

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

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

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