Tag: mainframe

Questions Related to mainframe

DECLARE CURSOR is executable.
technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

Count(*) ignores null

technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

subqueries cannot have union
technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

Sqlcode foreign key constraint is

technology mainframe

  1. 531

  2. 530

  3. 513

  4. 533

Show answer
Correct Option: B

default of orderby is

technology mainframe

  1. DSC

  2. ASC

  3. DSS

  4. ASS

Show answer
Correct Option: B

Which of the following is not an isolation type

technology mainframe

  1. RR

  2. CS

  3. RS

  4. SS

Show answer
Correct Option: D

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

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

Show answer
Correct Option: A,D

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

technology mainframe

  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;

Show answer
Correct Option: B

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

technology mainframe

  1. READ

  2. RECORD-IN

  3. @_RECORD

  4. IN/OUTRECORD

  5. 1_TELEPHONE

Show answer
Correct Option: A,C

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

  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

Show answer
Correct Option: B,D,E