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

What keyword does an SQL SELECT statement use for a string search?

2 8364

Which catalog table stores referential constraints?

1 6046

Give the COBOL definition of a VARCHAR field.

2 17015

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 11344

How to see the structure of db2 table??

IBM,

4 33273

what is the maximum number of tables that can be joined ?

IBM, TCS,

8 20962

What is normalization and what are the five normal forms?

1 5273

What are simple, segmented and partitioned table spaces ?

TCS,

1 13821

What is dynamic SQL?

ADP,

1 6986

What does CURRENTDATA option in bind indicate

IBM,

1 8998

What is the format (internal layout) of ?TIMESTAMP??

1 5840

What is the difference between group by and order by?

IBM, TCS,

2 14764

How many buffer pools are there in DB2?

2 7543

What are the three lock types?

2 6669

When is the access path determined for dynamic SQL?

2 9259

Un-Answered Questions { IBM MainFrame }

What is a scope terminator give example?

1166

What does a disposition of (new,catlg,keep) for a dsn mean?

1208

List some fields from sqlca?

1114

What is the difference between the mro & isc?

1127

What is the difference between cursor stability and repeatable read isolation levels?

1249

Can QSAM files be accessed from CICS?

1193

how are start and xctl different?

1015

Explain how do you access the records randomly in tsq?

1192

What is the function of finish in idms?

972

can you please let me know if there is any walkins for COBOL/PLI/DB2/IMS/JCL in pune other than IBM and ITC infotech

2503

What is dbdgen process?

1275

How many types of page locks can be held in db2?

1100

How would you understand error(execution phase)?

1339

What is NOTCAT ?

1384

How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?

2741

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