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

What is an ASRA

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

What is COMMAREA?

  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

AI Explanation

To answer this question, you need to understand what COMMAREA stands for and its purpose.

COMMAREA stands for Communication Area. It is an area used to pass information between programs in a mainframe environment.

Let's go through each option to understand why it is correct or incorrect:

Option A) A communication area for a terminal - This option is incorrect because COMMAREA is not specific to a terminal. It is used for communication between programs.

Option B) An area for an individual program to store all temporary flags - This option is incorrect because COMMAREA is not used for storing temporary flags. It is used for passing information between programs.

Option C) A communication area for processing data between CPUs - This option is incorrect because COMMAREA is not used for processing data between CPUs. It is used for passing information between programs.

Option D) An area used to pass information between programs - This option is correct because COMMAREA is indeed used to pass information between programs. It allows programs to exchange data and share information during program execution.

The correct answer is D. This option is correct because it accurately describes the purpose of COMMAREA as an area used to pass information between programs.

  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

Distinct keyword is used for.

  1. Add duplicates

  2. Remove duplicates

  3. Add duplicates and sort output

  4. None


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

Difference between UNION and UNION ALL.

  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

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

In Dynamic SQL ,The COMMIT or ROLLBACK statement destroys the prepared statement and the statement need to be prepared again.

  1. True

  2. False


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