0

mainframe Online Quiz - 90

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

Which parameter decides the allocation size for the tablespace

  1. Numpart

  2. SegSize

  3. Both 1 & 2

  4. None of the above


Correct Option: B

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

  1. ACQUIRE(USE)

  2. ACQUIRE(ALLOCATE)

  3. RELEASE(COMMIT)

  4. RELEASE(DEALLOCATE)


Correct Option: B

__________utility gathers information about data in tablespaces, indexes and updates DB2 catalog

  1. MERGE

  2. COPY

  3. REORG

  4. RUNSTATS


Correct Option: D

If a transaction successfully updates a record, it is imperative that it has an ________ on it

  1. Exclusive

  2. Shared

  3. Update

  4. None


Correct Option: A

If a table is dropped, the space for that table can be reclaimed with minimum reorg in

  1. Simple Tablespace

  2. Partitioned Tablespace

  3. Complex Tablespace

  4. Segmented Tablespace


Correct Option: D

DB2 Security is provided internal to DB2 using the

  1. Data Definition Language

  2. Data Manipulation Language

  3. Data Confusion Language

  4. Data Control Language


Correct Option: D
  1. TEST

  2. CHECK

  3. JCLCHK

  4. EJCL ALL


Correct Option: B

A list of the last names and salaries of all employees earning at least $40,000 a year. READ EMPLOYEES WITH SALARY STARTING FROM 40000 DISPLAY NAME SALARY END

  1. True

  2. False


Correct Option: A
  1. to scan a field for a specific value and replace it, and/ or to count how often it occurs

  2. the first occurrence or all occurrences of the string may be replaced, deleted or counted

  3. a & b

  4. NONE


Correct Option: C

What is name of the debug tool for natural programs

  1. DEBUG

  2. TEST

  3. CHECK

  4. XPEDITOR


Correct Option: B

Which parameter will be used to stop the execution of a step(which resides in the proc) in JCL.

  1. COND.STEPNAME=(GE,0)

  2. COND.STEPNAME=(0,GE)

  3. COND.STEPNAME=(0,LE)

  4. COND.STEPNAME=(LE,0)


Correct Option: C

What does abend code S806 signify

  1. Operation Exception

  2. Load module not found

  3. Index exceeds the size of the table

  4. COBOL sort failed


Correct Option: B

What does AVGREC parameter will do

  1. to specify the size of the file in terms of cylinders or tracks

  2. to specify the size of a new dataset in terms of the number of records

  3. to specify the size of the file in terms of bytes

  4. None


Correct Option: B
- Hide questions