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 45365

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

2 5927

What is a page?

2 5098

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

CTS,

1 10175

What is a collection?

3 6910

What does the CHECK Utility do ?

1 5641

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

2 5948

What are the various locking levels available?

3 6766

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

3 7432

What are the 4 environments which can access DB2 ?

2 7060

What is the picture clause of the null indicator variable?

6 19225

What will the FREE command do to a plan?

2 5833

What is a DB2 bind?

Logica CMG,

1 7295

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 9283

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 11079

Un-Answered Questions { IBM MainFrame }

What parameter directs the output of the job log dataset?

1276

how do you access an uncataloged dataset in a jcl?

1735

What is the function of job statement in jcl?

1086

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

2979

Explain index cardinality?

1053

What is the information associated with sysibm.syslinks table?

1120

How to submit jcl through a cobol program?

1145

Name and explain the type of locks?

953

How to do automated restart when a job abend?

1375

Define the attribute byte?

1146

How to Get Information About the Tables?

1683

How to execute stored procedures?

1128

Why include statement is used in a jcl?

1175

What is db2?

1174

suppose I have 1000 rows in a db2 table. I want to update first 100 records, how do I do it?

1115

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