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?

1108

How do you eliminate duplicate values in db2?

1194

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?

1153

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 2067

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

1055

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?

1301

Un-Answered Questions { IBM MainFrame }

What are the types of the dfhmdf present in the cics?

997

by using xpeditor if we want to debug the subpgm, how can you code in x-ped for mai-pgm n sub-pgm ?

2283

Explain the difference between temporary storage queue (tsq) and transient data quene (tdq)?

996

What are the pertinent COBOL

2570

If anyone has latest IBM Certification Dumps can you pls forwards it to me

2970

how do u start your process after conducting impact analysis ?

2127

Define acb?

3644

Name the 3 common ways to create maps?

1139

What are bind parameters in db2?

1048

What is null in db2?

1026

We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?

2409

Explain associator in adabas?

867

what is difference between file-aid tool and file-aid utility?

1504

Explain how do you intitiate another transaction?

1066

Explain about cursor stability?

1052

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