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

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

  1. Storage Group

  2. Database

  3. Synonym

  4. view


Correct Option: A

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

  1. Aliases

  2. Synonym

  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

In Partitioned Tablespace, individual partitions cannot be independently recovered and reorganized

  1. True

  2. False


Correct Option: B

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

DEFINE DATA LOCAL 1 #VAR-1 (A25) END-DEFINE MOVE 'THIS IS MY FIRST PROGRAM' TO #VAR-1 WRITE #VAR-1 END The above statements are correct or not.

  1. True

  2. False


Correct Option: A

Packed numeric, 7 positions before and 2 after decimal point and 1 sign position

  1. P7.2

  2. N7.2

  3. S7.2

  4. 7.2


Correct Option: A

Command used to catch the syntax errors

  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

What the EXAMINE command will do

  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

Which option will be used for spilitting the file using the records count

  1. OUTFIL FILES

  2. OUTREC FILES

  3. A & B

  4. NONE


Correct Option: A

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

Which parameter is used to call the jcl from another jcl

  1. JCLCAL

  2. INTRDR

  3. JCLCALL

  4. NONE


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