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 is a DB2 plan?

8 45408

How to define the data items to receive the fetch items for the SQL?

2 5940

What is a page?

2 5107

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

CTS,

1 10190

What is a collection?

3 6930

What does the CHECK Utility do ?

1 5654

Where could you look if you had a question about whether a column has been defined as an index?

2 5959

What are the various locking levels available?

3 6773

If I have a view which is a join of two or more tables, can this view be updatable?

3 7448

What are the 4 environments which can access DB2 ?

2 7083

What is the picture clause of the null indicator variable?

6 19259

What will the FREE command do to a plan?

2 5843

What is a DB2 bind?

Logica CMG,

1 7307

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 9298

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 11096

Un-Answered Questions { IBM MainFrame }

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8296

What is with ur in db2?

1320

how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)

2401

Explain isolation level?

1113

How to code the db2 queries using rexx, and also plz send some link and examples using db2 queries?

923

what optimum values can we find for freespace, ci etc?

1019

Explain the function of entry-sequenced data set?

1035

Define an aey9 abend?

1229

How do you get parameter from JCL to PL1?

2435

What are foreign keys in db2?

1108

What is role in db2?

1109

What is isolation level in db2?

1007

B37 abend during spufi?

1456

Explain the difference between link xctl?

1012

Define free space?

1059

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