0

mainframe Online Quiz - 132

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

STARTBR command is used to

  1. Read the file in sequential order

  2. Write the file

  3. To establish the starting position in a file

  4. All of the above.


Correct Option: C
  1. DB2/IDMS Database is not up

  2. Any data exception problem SOC7, SOC4 etc

  3. Runaway Task

  4. All of the above.


Correct Option: B
  1. To suspend the HANDLE CONDITION command

  2. To reactivate the HANDLE CONDITION command

  3. To PASS the HANDLE CONDITION command

  4. None of the above


Correct Option: A
  1. To suspend the HANDLE CONDITION command

  2. To reactivate the HANDLE CONDITION command

  3. To PASS the HANDLE CONDITION command

  4. None of the above


Correct Option: B

CICS can have the user interface with

  1. GUI Developed in VB using ECI calls

  2. Presentation logic devleloped on any platform using MQ Series

  3. Web applications through an Interner protocal like HTTP

  4. All of the above.


Correct Option: D

How can unusual conditions be handled in CICS.

  1. By writing an ALC exception handling routine

  2. With the RESP clause or HANDLE instructions.

  3. Calling the CICS Error Handler

  4. Via a call back routine.


Correct Option: B
  1. A communication area for a terminal.

  2. An area for an individual program to store all temporary flags.

  3. A communication area for processing data between CPUs.

  4. An area used to pass information between programs


Correct Option: D

What are the different types of tablespaces available.

  1. simple, hard, partitioned, unpartitioned

  2. partitioned, simple, lob, unpartitioned

  3. simple, lob, partitioned, segmented

  4. segmented, lob, hard, simple


Correct Option: C
  1. select, update, create, insert

  2. select, update, alter, modify

  3. alter, update, create, insert

  4. select, update, delete, insert


Correct Option: D
  1. Add duplicates

  2. Remove duplicates

  3. Add duplicates and sort output

  4. None


Correct Option: C

What is auxillary table.

  1. It contains only numeric data

  2. It contains only character data

  3. It contains data like image, voice and doc’s.

  4. None of these


Correct Option: C
  1. Union wont remove the duplicate and it wont invoke the sort operation.

  2. Union all will remove the duplicate and it wont invoke the sort operation.

  3. Union won't remove the duplicate and it will invoke the sort operation.

  4. Union all will remove the duplicate and it will invoke the sort operation.


Correct Option: A

A host variable structure can allow to contain an OCCURS clause.

  1. True

  2. False


Correct Option: B

Dynamic SQL statements are embedded in programs and bound before they are executed.

  1. True

  2. False


Correct Option: B

The COBOL copy statements will be expanded during pre-compile stage.

  1. True

  2. False


Correct Option: B

SQL data type DATE, TIME or TIMESTAMP will be accdepted as character strings in COBOL program

  1. True

  2. False


Correct Option: B

The data definition of Null indicator variables in cobol/DB2 program is ?

  1. PIC S9(09) COMP

  2. PIC S9(04) COMP

  3. PIC S9(8) COMP

  4. PIC 9(08) COMP


Correct Option: B

Which step analyzes all the static SQL and stores the more efficient path to the data in a plan/package while compiling a cobol/DB2 program

  1. Precompile

  2. Package

  3. Bind

  4. Plan


Correct Option: C
- Hide questions