0

mainframe Online Quiz - 114

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

Which of the following are the lock types?

  1. shared

  2. update

  3. exclusive

  4. All of the above


Correct Option: D

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

  1. 05

  2. 41

  3. 35

  4. 91


Correct Option: A,C

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

  1. successful completion

  2. Record or file not found

  3. End of file reached

  4. dupliacate key


Correct Option: C

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

  1. 00

  2. 92

  3. 07

  4. 97


Correct Option: A,D

File status code 86 indicates 'VSAM - MISSING DD STATEMENT IN JCL'. True or false?

  1. True

  2. False


Correct Option: B

An Index can be defined if the table size is less than 10 PAGES

  1. True

  2. False


Correct Option: B

What is the maximum number of tables that can be stored on a Partitioned Table Space?

  1. 1

  2. 2

  3. 3

  4. 4


Correct Option: A

The best locksize that you could use when you create a tablespace is ANY.

  1. True

  2. False


Correct Option: A

SQLCABC contains value of SQLCA.

  1. True

  2. False


Correct Option: A

CPU processing is more important for DB2 system performance.

  1. True

  2. False


Correct Option: B

DECLARE CURSOR is executable.

  1. True

  2. False


Correct Option: B

88 level used for

  1. condition names

  2. RENAMES clause

  3. All the above

  4. None


Correct Option: A

77 level used for

  1. Elementary level item

  2. condition names

  3. RENAMES clause.

  4. All the above


Correct Option: A

level 66 used for

  1. Elementary level item

  2. Condition names.

  3. RENAMES clause

  4. All the above


Correct Option: C

SEARCH command used for

  1. binary search & the table must be sorted

  2. serial search

  3. binary search

  4. All the above


Correct Option: B

TYPERUN=JSCAN in the JOB card is used to check the syntax of the JCL without running it.

  1. True

  2. False


Correct Option: B
- Hide questions