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 keyword does an SQL SELECT statement use for a string search?

2 8390

Which catalog table stores referential constraints?

1 6068

Give the COBOL definition of a VARCHAR field.

2 17036

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 11372

How to see the structure of db2 table??

IBM,

4 33315

what is the maximum number of tables that can be joined ?

IBM, TCS,

8 21004

What is normalization and what are the five normal forms?

1 5291

What are simple, segmented and partitioned table spaces ?

TCS,

1 13831

What is dynamic SQL?

ADP,

1 7007

What does CURRENTDATA option in bind indicate

IBM,

1 9005

What is the format (internal layout) of ?TIMESTAMP??

1 5856

What is the difference between group by and order by?

IBM, TCS,

2 14790

How many buffer pools are there in DB2?

2 7560

What are the three lock types?

2 6694

When is the access path determined for dynamic SQL?

2 9286

Un-Answered Questions { IBM MainFrame }

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

2313

What is the latest version of ibm db2?

1358

Are you comfortable in cobol or jcl?

1106

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

2166

List the type of locks and explain each of them.

986

pls send the docs of any telecommunication mainframe project

2214

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

4544

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

2471

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

2289

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

2111

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.

1801

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