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 is the command used by TSO users to invoke DB2?

IBM,

2 9528

What is the FREE command?

1 5290

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2916

What is DB2 (IBM Database 2)?

3 5797

What is QUIESCE?

2 13329

what is the name of the default db2 catalog database?

IBM,

3 8692

What are the three DB2 date and time data types and their associated functions?

1 5500

What is the significance of DB2 free space and what parameters control it?

1 5617

Explain the EXPLAIN statement?

1 5071

What is a DBRM, PLAN ?

3 18752

What's the maximum number of characters that a tablename can have?

3 9022

What technique is used to retrieve data from more than one table in a single SQL statement?

CTS, IBM, TCS,

9 16086

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 5016

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?

2119

Why use RUNSTAT Utility?

Merrill Lynch,

3 24102

Un-Answered Questions { IBM MainFrame }

Explain the primary significance of intra-partition and extra-partition tdqs ?

1135

What are the 2 sqlcodes that are returned?

1243

What is downtime and what might be the reason?

1188

In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?

1523

Differentiate between control interval (ci) and control area (ca)?

1059

How to declare host variables?

1065

How many root segments do we have per database record?

1101

What is the need for a secondary index in ims?

1127

Can we see the copy book length using file-aid?

969

difference between tsq and tdq?

1272

Which mode is used to operate the sequential file?

1257

How to get the ddl of a table in db2?

1180

How can you quickly find out the # of rows updated after an update statement?

1100

How do define dynamic array in cobol. how do you define single dimensional array and multidimensional array in your cobol?

1314

Can you use occurs in bms map?

1116

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