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

Name the different types of Table spaces.

IBM,

5 15464

How do you retrieve the data from a nullable column?

2 8853

What is a clustering index ?

3 7553

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 7069

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 9123

What else is there in the PLAN apart from the access path?

1 5278

What is a host variable?

3 6911

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 10321

Once you create a view, where would information about the view be stored?

1 5080

What information is used as input to the bind process?

2 7479

Can I use LOCK TABLE on a view?

1 6898

Are views updatable ?

4 12657

Give some example of statistics collected during RUNSTATS?

1 5888

What is referential integrity?

5 19953

What is EXPLAIN?

1 6199

Un-Answered Questions { MainFrame }

How to receive data passed through jcl parm parameter in a natural program? How data definition is defined in the program?

1096

Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?

1126

Define floating maps with illustration?

1019

In Which Specs Arrays, Tables & Constants Are Defined?

1179

what is the purpose of data structure?

1757

what are the uses of factor1, factor2 and result field for the rpg operation code parm?

1049

What are the different types of condition in cobol and write their forms.

1125

how to get the last record in vsam file in cluster? And how can u get the ksds file records into ur cobol program?

983

How is the sorting of vsam files carried?

1142

How to get the last record in vsam file in cluster? And how can u get the ksds file records into cobol program?

1046

What is the function of the dd avgrec keyword in sms datasets?

1351

how many levels are there in a physical file?

1808

How do you handle exception in PL/1?

1671

what is a program described file in rpg?

1755

Explain paging concept in memory?

1030

For More Un-Answered { MainFrame } Questions Click Here