IBM MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

COBOL (1072)
JCL (1031)
CICS (755)
DB2 (1122)

IMS (143)
IDMS (107)
Natural (81)
ADABAS (26)

REXX (60)
Assembler (68)
CLIST (6)
QMF (32)

MVS (25)
OS390 (10)
OS 2 (7)
VSAM (319)

IBM MainFrame Interview Questions

Questions Answers Views Company eMail

Name the different types of Table spaces.

IBM,

5 15629

How do you retrieve the data from a nullable column?

2 8941

What is a clustering index ?

3 7669

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 7141

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 9208

What else is there in the PLAN apart from the access path?

1 5357

What is a host variable?

3 7038

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 10415

Once you create a view, where would information about the view be stored?

1 5152

What information is used as input to the bind process?

2 7559

Can I use LOCK TABLE on a view?

1 6965

Are views updatable ?

4 12861

Give some example of statistics collected during RUNSTATS?

1 5955

What is referential integrity?

5 20136

What is EXPLAIN?

1 6250

Un-Answered Questions { IBM MainFrame }

Is condition checking possible in jcl?

1267

What is the difference between an obtain next and obtain first in idms?

947

How jcl work to handle various input output file operations?

1228

What are the rules for db2 programming?

1162

What is mpp mode?

1189

Explain How will you the specification of database file?

980

If an array is multi-dimensional dynamic array how do you deal with it & provide me some examples?

2508

How can a stopped job be started again?

1248

what do you mean by a vsam split?

1155

what is the differences between getting the system time with eibtime and asktime command?

1197

What are INPUT PROCEDURE and OUTPUT PROCEDURE?

1374

My program has an array defined to have 10 items. Due to a bug, I find that even if the program access the 11th item in this array, the program does not abend. What is wrong with it?

1146

what about F1 & F2 keys in xpeditor? And their functionalities?

2585

without jcl how to run the batch programs

2590

Write a cobol program making use of the redefine clause.

1231

For More Un-Answered { IBM MainFrame } Questions Click Here