MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

Are views updateable?

1155

What is reorg?

1160

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

1116

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1090

What is meant by dclgen?

1109

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1092

How is a typical db2 batch pgm executed?

1174

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

1069

Name the various locking levels available?

1091

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?

1104

How do you eliminate duplicate values in db2?

1190

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

1076

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

1149

When do you specify the isolation level?

1030

Un-Answered Questions { MainFrame }

Define adabas?

979

What Is Ddm ?

1698

What is the draw back of Procedures? why we are going to Modules?

1792

Define the necessity of run stats among the environment test?

983

What is the need of base registers in IBM 360/370?

2648

pls send the docs of any telecommunication mainframe project

2166

What is the difference between non-join logical files and join logical files?

1122

can we view the access paths created by dbrm ? how ? thx

7096

What are the utility programs in jcl?

1161

Write the code implementing the perform … varying.

1064

at what level s,o are defined and what they will do?

1802

What r the comman abends in db2, jcl and cobol???????

2253

what is a logical file?

1812

Is their any limit for data sets?

1188

What is dbrm?

1105

For More Un-Answered { MainFrame } Questions Click Here