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?

1160

What is reorg?

1161

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?

1092

What is meant by dclgen?

1110

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

1095

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

Un-Answered Questions { MainFrame }

What is the function of //cntl statement?

1336

What are types of indexes?

1074

what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.

6921

Explain the significance of the shareoptions parameter?

1012

Define predicate?

1132

Explain adabas basic concepts. Like inverted list, address converter ,data storage?

993

How do we specify index to include or not during bind process.

2126

) how do u code after getting data?

2153

Can you define cemt?

1055

Tell about how do you eliminate the duplicates?

1006

if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.

2631

execution of a subordinate module is caused by the use of the cobol verbs ------------in the superior module

1079

What is PL/I?

1408

How to handle exceptional conditions in cics?

1137

List the various advantages of using jcl language?

1453

For More Un-Answered { MainFrame } Questions Click Here