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

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

PUSH command is used

  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

POP command is used

  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

AI Explanation

To answer this question, you need to understand the purpose of the POP command in relation to the HANDLE CONDITION command.

The POP command is used to reactivate the HANDLE CONDITION command.

Option A) To suspend the HANDLE CONDITION command - This option is incorrect because the POP command does not suspend the HANDLE CONDITION command. Instead, it reactivates it.

Option B) To reactivate the HANDLE CONDITION command - This option is correct because the POP command is used to reactivate the HANDLE CONDITION command.

Option C) To PASS the HANDLE CONDITION command - This option is incorrect because the POP command does not pass the HANDLE CONDITION command. It is used to reactivate it.

Option D) None of the above - This option is incorrect because option B is the correct answer.

Therefore, the correct answer is option B) To reactivate the HANDLE CONDITION command.

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

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.

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

Which are the four data modification db2 statements.

  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

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

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

What is the communication area between DB2 and cobol to communicate the error codes.

  1. DCLGEN

  2. SQLCA

  3. SQLSTATE

  4. SQLCODE


Correct Option: B

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

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