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

What is a result table?

1 5659

What is the SQL Communications Area and what are some of its key fields?

1 5045

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 4302

How would one remove old reorg information from the DB2 catalog?

2 6482

The only place of VSAM KSDS in DB2 is?

IBM,

2 8040

What is DCLGEN?

2 15787

Where is the output of EXPLAIN stored?

2 6868

What is the function of buffer manager?

1 5778

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

2 6526

What is a lock?

1 4981

What should be specified along with a cursor in order to continue updating process after commit?

IBM,

1 5442

How does DB2 use multiple table indexes?

1 5831

What is meant by repeatable read?

4 10481

Compare a subselect to a join?

1 5003

Describe the elements of the SELECT query syntax?

3 6531

Un-Answered Questions { MainFrame }

How can we override a file during runtime in rpg?

1216

What is currency in idms?

977

Explain the uses that are associated to tsq and tdq ?

1099

Explain path?

1012

What is the syntax for seeing the columns and data types of a table in the db2 database?

1183

What are the processing modes available in ims db?

1089

How can record locking be achieved in those DB2 versions which do not support it?

1092

how do you execute a background cics txn ?

1328

How to execute stored procedure in db2 command editor?

1060

In the house keeping section of an MVS assembly language program, like the one below STM R14,R12,12(R13) BASR R12,R0 USING *,R12,R11 LA R11,2048 LA R11,2048(R11,R12) .... .... 1. What if BASR R12,R0 IS NOT PRECEDE USING *,R12,R11? 2. USING (base address), REGISTER does USING directive says assembler to treat particular Register as a base register with the mentioned base address..in the above case * i.e current location counter..well if that is the case why we need BASR R12,R0 ? 3. What if I write like STM R14,R12,12(R13) BASR R12,R0 LA R11,2048 LA R11,2048(R11,R12) USING *,R12,R11 there is no address resolution being calculated in both LA statements so is it a right way to set Base register?..will there be any issues with Domain regarding R11 and R12?

1993

Can there be more than one cursor open for any program?

1186

Explain difference between call and link?

1116

What is condition checking in jcl? Is this possible?

1129

how to pass parms to ispf edit macro?

1115

Which component is used to execute the sql statements?

1111

For More Un-Answered { MainFrame } Questions Click Here