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

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 5629

max number of columns in a db2 table?

6 25062

Can you access the DB2 Directory table using SQL?

3 7650

What is correlation names?

1 4848

What is an alias?

3 6310

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 6576

What is the difference between Where and Having Clause

IBM, iFlex,

7 30495

Which transaction use a command thread ?

1 3806

What is a LIKE table and how is it created?

2 5508

Name some fields from SQLCA.

2 6559

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

Cap Gemini, Tech Mahindra,

3 18349

What are the isolation levels possible ?

3 7055

What is meant by index cardinality?

2 6578

What does the RUNSTATS Utility do?

4 20666

What is the purpose of the QUIESE Utility?

1 5170

Un-Answered Questions { IBM MainFrame }

What is the use of tdq and tsq?

1113

When an area sweep is used?

842

What happens when you issue a escape routine in a program? Will there be any compilation /run time erro?

1008

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

Explain about area currency?

853

When the like statement is used?

1222

Explain the three location modes?

902

How do you access an uncatalogued dataset in a jcl?

1219

Define predicate?

1139

there are seven idcams commands in vsam. Can you name and explain each of them?

1112

How do you eliminate duplicate values in db2?

1194

Is it slower if you access a record through alt index as compared to primary index?

1022

Which isolation level provides maximum concurrency?

1152

What are the benefits of using the db2 database?

1229

which is the cics control program that provides communication services between user written application programs and terminals?

998

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