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 5129

What does the sqlcode of -818 pertain to?

3 7743

How many clustering indexes can be defined for a table?

2 7254

What is tablespace?

3 6817

What is the function of the Data Manager?

2 5335

What is a SELECT statement?

1 4502

How do you define a correlated name?

1 4083

What is the self-referencing constraint?

2 6484

What is a buffer pool?

2 6604

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

1 5680

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

5 9502

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

1 13695

What is meant by isolation level?

3 6950

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 7024

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 5292

Un-Answered Questions { IBM MainFrame }

what u mean by csrloc and rtncsrloc in rpgIV in as/400.Give an eg? to do...give some coding...what is row no and column no ???..if possible...give a no of lines coding....please

4533

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2103

Are you comfortable in cobol or jcl?

1098

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1797

List the type of locks and explain each of them.

985

can any body give me any website for getting help on mainframe projectts in banking domain.

2157

Is it rquired any server for Ibm framework? Give me list of Ibm framework & recent version IBm framework?

2309

PLEASE SEND ME THE DOCUMENTS IF ANY ONE HAVE REGARDING THE IMPACT ANALYSYS,REVIEWS

2464

pls send the docs of any telecommunication mainframe project

2208

i need a small 3d program using inline and outline.

2279

What is the latest version of ibm db2?

1352

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