Tag: mainframe

Questions Related to mainframe

What will be the value of B after executing the below code snippet? 77 A PIC 9(4)V999 VALUE 9902.852. 77 B PIC 9(4)V9(2) VALUE 99.85. PROCEDURE DIVISION. MULTIPLY A BY 30.5 GIVING B ROUNDED STOP RUN.
technology mainframe

  1. B will have 2

  2. B will have 0002000

  3. B will have 2662311

  4. Program will abend

Show answer
Correct Option: D

What is the precedence rule (from highest to lowest) applied for a complex condition if parentheses are not used.

technology mainframe

  1. Arithmetic, Relational, NOT, AND, OR

  2. Relational, Arithmetic, NOT, AND, OR

  3. Arithmetic, Relational, AND, OR, NOT

  4. Arithmetic, Relational, OR, AND, NOT

Show answer
Correct Option: A

Which one of the following is not an integrity?
technology mainframe

  1. Domain Integrity

  2. Entity Integrity

  3. Technology Integrity

  4. Referential Integrity

Show answer
Correct Option: C

What is the function of a precompiler ?
technology mainframe

  1. Extracts the SQL statements and place them into load.

  2. Extracts the SQL statements and place them into DBRM.

  3. Extracts the COBOL statements and place them into DBRM.

  4. Extracts the COBOL statements and place them into load.

Show answer
Correct Option: B

How many Indexes can be built on a table ?
technology mainframe

  1. No limit

  2. 4

  3. 15

  4. none

Show answer
Correct Option: A

What is SPUFI ?
technology mainframe

  1. SQL Process Used File Input.

  2. SQL Processing Using Format Input

  3. SQL Processing Using File Input

  4. SQL Processing Using File Information.

Show answer
Correct Option: C

Which of the following are the lock types?
technology mainframe

  1. shared

  2. update

  3. exclusive

  4. All of the above

Show answer
Correct Option: D

Which VSAM file status code indicates that you are tring to open a VSAM file that is not present?

technology mainframe

  1. 05

  2. 41

  3. 35

  4. 91

Show answer
Correct Option: A,C

What does a VSAM file status code '10' indicate?
technology mainframe

  1. successful completion

  2. Record or file not found

  3. End of file reached

  4. dupliacate key

Show answer
Correct Option: C

When you try to open a VSAM file, which of the following status codes are acceptable?
technology mainframe

  1. 00

  2. 92

  3. 07

  4. 97

Show answer
Correct Option: A,D