0

mainframe Online Quiz - 94

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

What is Endevor?

  1. A Version Control Tool for elevating components into production

  2. a Source Control tool that always ensures we modify the latest version of the code

  3. a Tool that allows you to automate & control the movement of code during the SDLC

  4. Only Choice 1 & Choice 2

  5. All the above

  6. None of the above


Correct Option: E

Which of the following statement falls under Data Control Language ?

  1. CREATE

  2. INSERT

  3. DROP

  4. GRANT


Correct Option: D

Which of the following error code is displayed when the column name is not a column of table name?

    • 205
    • 206
    • 207
    • 208

Correct Option: A

Which of the environments cannot access DB2?

  1. TSO

  2. IMS

  3. BATCH

  4. All the above can access


Correct Option: D

Which of the following statement establishes Syncpoint when an unsuccessful end of transaction is signaled?

  1. COMMIT

  2. ROLLBACK

  3. ALLOCATE

  4. DEALLOCATE


Correct Option: B

----- can be bound for single DBRM only.

  1. Plan

  2. Package

  3. Load

  4. Collection


Correct Option: B

Number of Tables that can be joined in a single query are

  1. 8

  2. 15

  3. 16

  4. 256


Correct Option: B

Which is of the following error code is returned when Program name is not found in plan?

    • 802
    • 803
    • 804
    • 805

Correct Option: D

AI Explanation

To answer this question, we need to understand the error codes returned when a program name is not found in a plan.

Option A) -802 - This option is incorrect because error code -802 is typically returned when a plan or package is not found.

Option B) -803 - This option is incorrect because error code -803 is typically returned when a duplicate key violation occurs.

Option C) -804 - This option is incorrect because error code -804 is typically returned when a plan or program was not found in the database.

Option D) -805 - This option is correct because error code -805 is typically returned when a program name is not found in a plan.

The correct answer is D) -805. This option is correct because error code -805 is specifically associated with program name not found in a plan.

Which is the formal relational term for the 'Number of Columns'?

  1. Degree

  2. Attribute

  3. Cardinality

  4. Domain


Correct Option: A

What is Endevor?

  1. A Version Control Tool for elevating components into production

  2. a Source Control tool that always ensures we modify the latest version of the code

  3. a Tool that allows you to automate & control the movement of code during the SDLC

  4. Only Choice 1 & Choice 2

  5. All the above

  6. None of the above


Correct Option: E

CCID Field?

  1. To group components together for easy retrieval

  2. A unique ID that logs every action on an element

  3. A single ID used by all Teammembers of the same team, for better control on the elements

  4. All the above

  5. None of the above


Correct Option: D

Build Using Map?

  1. To search the environment map when building a list of elements

  2. To search the system map when building a list of elements

  3. To search the subsystem map when building a list of elements

  4. To search the dataset when building a list of elements


Correct Option: A

Route for Moving Across Regions

  1. DEV01->ASM00->INT01->ACC00->PRD00

  2. DEV01->INT01->ACC00->ASM00->PRD00

  3. INT01->Dev01->ASM00->ACC00->PRD00

  4. DEV01->INT01->ASM00->ACC00->PRD00


Correct Option: D

Override Signout

  1. The System sends a request to the user who has signed-out the component so that the new user can edit / modify the same

  2. The system waits for the user signed out to sign-in the component

  3. The system ignores the sign-out of the user

  4. The system explicitly signs out the element for performing any action, irrespective of anyone else who has signed-out the same


Correct Option: D

Promotion Package Actions

  1. move, delete, add

  2. move, add

  3. move, delete

  4. move only

  5. add only


Correct Option: D

Program & Copybook

  1. A program can be created & generated, and then the copybooks can be created & generated

  2. A copybook has to be created before creating & generating the program

  3. A copybook has to be created & generated before creating & generating the program

  4. None of the above is true


Correct Option: C

Retrieve Copybooks

  1. By scanning all programs individually, giving a search for the text

  2. by using a scan elements feature in Endevor

  3. by using the 'WHERE USED' option in Endevor

  4. all the above


Correct Option: D

Footpring Mismatch

  1. When you try to move a program to another region that contains a version of the program that you didn't use for editing

  2. when you try to move a program to another region via Emergency

  3. when you move a program to a higher region

  4. None of the above


Correct Option: A
- Hide questions