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 8233

Which catalog table stores referential constraints?

1 5957

Give the COBOL definition of a VARCHAR field.

2 16877

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

2 11150

How to see the structure of db2 table??

IBM,

4 33053

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

IBM, TCS,

8 20653

What is normalization and what are the five normal forms?

1 5136

What are simple, segmented and partitioned table spaces ?

TCS,

1 13728

What is dynamic SQL?

ADP,

1 6864

What does CURRENTDATA option in bind indicate

IBM,

1 8896

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

1 5736

What is the difference between group by and order by?

IBM, TCS,

2 14621

How many buffer pools are there in DB2?

2 7411

What are the three lock types?

2 6542

When is the access path determined for dynamic SQL?

2 9118

Un-Answered Questions { IBM MainFrame }

Explain how can the attributes of one sms dataset be copied to another dataset?

1212

When the job statement is used?

971

What is mainframe cics?

1103

What is the difference between plan and package in db2?

1106

How do you create a like table?

966

Define a page in idms?

820

Explain the device independent method to indicate where a record is stored?

915

we cant write data into file using cl program then what is sndf

1653

what is the use of JCL?

1152

How many bytes will a s9(8) comp field occupy ?

1121

What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?

1195

What db2 400?

1172

why ci and ca splits are not possible in esds and rrds?

1153

What are union and union all?

976

what are JCLLIB and STEPLIB in JCL?

1169

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