Tag: mainframe

Questions Related to mainframe

EJECT is used for creating a new page in the compiler listing.
technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

For successful execution of REWRITE stmt, the direct access file must be opened in _____ mode.
technology mainframe

  1. I

  2. O

  3. I-O

  4. O-I

Show answer
Correct Option: C

ASCENDING/DESCENDING KEY data item cannot be floating point items.
technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

The SYNCHRONIZED LEFT / RIGHT clause which specifies alignment of elementary data item on storage boundary can be specified for data items defined with USAGE IS INDEX.
technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

The maximum size of a Tablespace can be
technology mainframe

  1. 64 Gb

  2. 32 Gb

  3. 8 Kb

  4. 4 Kb

Show answer
Correct Option: A

Which one is not a pre-compile parameter
technology mainframe

  1. Level

  2. Host()

  3. APost

  4. Time

Show answer
Correct Option: D

Which parameter decides the allocation size for the tablespace

technology mainframe

  1. Numpart

  2. SegSize

  3. Both 1 & 2

  4. None of the above

Show answer
Correct Option: B

________is a collection of direct access volumes all of the same device type.

technology mainframe

  1. Storage Group

  2. Database

  3. Synonym

  4. view

Show answer
Correct Option: A

________means another name for the table, but is private to the user who created it.

technology mainframe

  1. Aliases

  2. Synonym

  3. Both 1 & 2

  4. None of the above

Show answer
Correct Option: B

Opens all tablespaces and acquires all tablespace locks when the plan is allocated

technology mainframe

  1. ACQUIRE(USE)

  2. ACQUIRE(ALLOCATE)

  3. RELEASE(COMMIT)

  4. RELEASE(DEALLOCATE)

Show answer
Correct Option: B