Question 1

Which parameter decides the allocation size for the tablespace

technology mainframe

Numpart
SegSize
Both 1 & 2
None of the above

Answer

Correct Option: B

Question 2

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

technology mainframe

Storage Group
Database
Synonym
view

Answer

Correct Option: A

Question 3

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

technology mainframe

Aliases
Synonym
Both 1 & 2
None of the above

Answer

Correct Option: B

Question 4

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

technology mainframe

ACQUIRE(USE)
ACQUIRE(ALLOCATE)
RELEASE(COMMIT)
RELEASE(DEALLOCATE)

Answer

Correct Option: B

Question 5

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

technology mainframe

MERGE
COPY
REORG
RUNSTATS

Answer

Correct Option: D

Question 6

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

technology mainframe

Exclusive
Shared
Update
None

Answer

Correct Option: A

Question 7

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

technology mainframe

Simple Tablespace
Partitioned Tablespace
Complex Tablespace
Segmented Tablespace

Answer

Correct Option: D

Question 8

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

technology mainframe

True
False

Answer

Correct Option: B

Question 9

DB2 Security is provided internal to DB2 using the

technology mainframe

Data Definition Language
Data Manipulation Language
Data Confusion Language
Data Control Language

Answer

Correct Option: D

Question 10

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.

technology mainframe

True
False

Answer

Correct Option: A

Question 11

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

technology mainframe

P7.2
N7.2
S7.2
7.2

Answer

Correct Option: A

Question 12

Command used to catch the syntax errors

technology mainframe

TEST
CHECK
JCLCHK
EJCL ALL

Answer

Correct Option: B

Question 13

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

technology mainframe

True
False

Answer

Correct Option: A

Question 14

What the EXAMINE command will do

technology mainframe

to scan a field for a specific value and replace it, and/ or to count how often it occurs
the first occurrence or all occurrences of the string may be replaced, deleted or counted
a & b
NONE

Answer

Correct Option: C

Question 15

What is name of the debug tool for natural programs

technology mainframe

DEBUG
TEST
CHECK
XPEDITOR

Answer

Correct Option: B

Question 16

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

technology mainframe

COND.STEPNAME=(GE,0)
COND.STEPNAME=(0,GE)
COND.STEPNAME=(0,LE)
COND.STEPNAME=(LE,0)

Answer

Correct Option: C

Question 17

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

technology mainframe

OUTFIL FILES
OUTREC FILES
A & B
NONE

Answer

Correct Option: A

Question 18

What does abend code S806 signify

technology mainframe

Operation Exception
Load module not found
Index exceeds the size of the table
COBOL sort failed

Answer

Correct Option: B

Question 19

Which parameter is used to call the jcl from another jcl

technology mainframe

JCLCAL
INTRDR
JCLCALL
NONE

Answer

Correct Option: B

Question 20

What does AVGREC parameter will do

technology mainframe

to specify the size of the file in terms of cylinders or tracks
to specify the size of a new dataset in terms of the number of records
to specify the size of the file in terms of bytes
None

Answer

Correct Option: B

Description: mainframe Online Quiz - 90
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: mainframe

mainframe Online Quiz - 90

Find more quizzes from top tags