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

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 5123

What does the sqlcode of -818 pertain to?

3 7734

How many clustering indexes can be defined for a table?

2 7238

What is tablespace?

3 6801

What is the function of the Data Manager?

2 5331

What is a SELECT statement?

1 4495

How do you define a correlated name?

1 4081

What is the self-referencing constraint?

2 6478

What is a buffer pool?

2 6600

What is the cascade rule and how does it relate to deletions made with a subselect?

1 5672

When is the results table for the query in a DECLARE CURSOR statement created?

5 9493

What does it mean if the null indicator has -1, 0, -2?

1 13690

What is meant by isolation level?

3 6942

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 7006

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 5282

Un-Answered Questions { IBM MainFrame }

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

1193

Write about a ‘view’ in brief?

1021

What is copy pending status in db2?

1194

How many databases are there?

1117

Explain the difference between a package and a plan.

1139

List the type of locks?

988

Can we move alphanumeric incentive to the numeric field?

1133

How to Build a Row Condition?

1782

how can you load a vsam data set with records ?

1225

Mention the option used in a cics command to retrieve the response code after execution of the command?

1162

what is the resolution for sb37 error

9279

How do you differentiate between cobol and cobol-ii?

1303

Can there be more than one cursor open for any program?

1231

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1158

What is concatenating?

1146

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