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 5024

What does the sqlcode of -818 pertain to?

3 7574

How many clustering indexes can be defined for a table?

2 7097

What is tablespace?

3 6657

What is the function of the Data Manager?

2 5186

What is a SELECT statement?

1 4398

How do you define a correlated name?

1 3984

What is the self-referencing constraint?

2 6336

What is a buffer pool?

2 6465

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

1 5561

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

5 9246

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

1 13577

What is meant by isolation level?

3 6793

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 6847

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 5157

Un-Answered Questions { IBM MainFrame }

What is inspect and what is it used for?

971

what is buffering and how does it apply to vsam files ?

1170

Particular area has been affected in cics screen, what is the process to find?

9881

What is a storage group (stogroup)?

1241

List the type of locks and explain each of them.

932

What is commarea (communications area)?

1004

What is the maximum value that can be stored in s9(8) comp?

1044

What are INPUT PROCEDURE and OUTPUT PROCEDURE?

1293

What is a db2 tablespace?

1059

Explain difference between call and link?

1090

What is mainframe testing?

1101

Define cobol coding sheet?

1002

State the maximum number of tables that can be joined?

987

What is db2 catalog database?

1036

can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there

2469

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