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 15408

How do you retrieve the data from a nullable column?

2 8817

What is a clustering index ?

3 7523

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

1 7048

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 9087

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

1 5248

What is a host variable?

3 6865

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 10301

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

1 5062

What information is used as input to the bind process?

2 7445

Can I use LOCK TABLE on a view?

1 6877

Are views updatable ?

4 12593

Give some example of statistics collected during RUNSTATS?

1 5866

What is referential integrity?

5 19915

What is EXPLAIN?

1 6180

Un-Answered Questions { IBM MainFrame }

How many minimum number of line codes does PL/1 DB2 program requires?

2979

Explain the difference between various read and find statement and which one should be used when for better adabas performance?

987

What are the contents of a dclmgen?

1122

Portfolio analysis application is an example of?

1131

Explain the function of the load command?

1123

What is access path in db2?

982

What are the pertinent COBOL commands?

3172

How dummy is used in jcl?

1147

What is the use of qsam?

815

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2933

What is the difference between fixed length and variable length records?

872

What is the difference between goback, stop run and exit program in cobol?

1583

What do you understand by psb and acb?

1119

how to initialize a register to 0000?

1136

What does the keyranges parameter in define cluster command do?

1042

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