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 15409

How do you retrieve the data from a nullable column?

2 8818

What is a clustering index ?

3 7525

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

1 7049

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 9087

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

1 5248

What is a host variable?

3 6867

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 10302

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

1 5063

What information is used as input to the bind process?

2 7445

Can I use LOCK TABLE on a view?

1 6878

Are views updatable ?

4 12593

Give some example of statistics collected during RUNSTATS?

1 5866

What is referential integrity?

5 19915

What is EXPLAIN?

1 6181

Un-Answered Questions { MainFrame }

How many minimum number of line codes does PL/1 DB2 program requires?

2980

Explain in brief how does db2 determine what lock-size to use?

1037

what are the different opcodes available in rpg for database access ?

1698

How to handle exceptional conditions in cics?

1130

what does dfu program you to do on a record?

1219

How To Compile The COBOL-BD2-CI CS Programs In Real TIme? Please Give Me the Detailed Description?

6747

what happens if parmparameter passes zero bytes to the program

2128

What is the purpose of idcams?

1044

What is performance tuning db2?

1058

What are the benefits of using the db2 database?

1224

Does jcl support automatic restart?

1224

What is iseries database?

1046

what is the length of a variable in rpg?

1676

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1183

Explain index cardinality?

1053

For More Un-Answered { MainFrame } Questions Click Here