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

How is a typical db2 batch pgm executed?

1176

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

Name the various locking levels available?

1093

Explain how can you do the explain of a dynamic sql statement?

1125

How do you find the maximum value in a column in db2?

1106

How do you eliminate duplicate values in db2?

1192

How do you concatenate the firstname and lastname from emp table to give a complete name?

1077

How do you pull up a query which was previously saved in qmf?

1151

When do you specify the isolation level?

1032

Explain in brief how does db2 determine what lock-size to use?

1045

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 2066

How would you find out the total number of rows in a db2 table?

1053

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What are the contents of dclgen?

1112

Why select is not preferred in embedded sql programs?

1299

Un-Answered Questions { IBM MainFrame }

What is an area sweep and when is it used?

1545

How do define dynamic array in cobol.

1135

Explain ims software environment?

979

What are the cobol coding sheets?

1271

what is swap-in and swap-out?

1099

what is effect on receive map when

1267

is it required that primary key values have to be unique? Do alternate key values have to be unique?

1054

Define an aey9 abend?

1228

What is the maximum number of levels allowed in ims db?

987

What is node in db2?

1044

Explain about dbrm.

1047

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

1022

How do you eliminate the duplicates?

919

which parameter is use to declare the name of dataset in dd statement?

1267

What is the connection string to connect to the DB2 Database ?

1128

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