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 DB2 plan?

8 45743

How to define the data items to receive the fetch items for the SQL?

2 6036

What is a page?

2 5229

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

CTS,

1 10281

What is a collection?

3 7077

What does the CHECK Utility do ?

1 5743

Where could you look if you had a question about whether a column has been defined as an index?

2 6081

What are the various locking levels available?

3 6916

If I have a view which is a join of two or more tables, can this view be updatable?

3 7601

What are the 4 environments which can access DB2 ?

2 7221

What is the picture clause of the null indicator variable?

6 19506

What will the FREE command do to a plan?

2 5989

What is a DB2 bind?

Logica CMG,

1 7422

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 9410

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 11223

Un-Answered Questions { MainFrame }

What are the different rules for performing sort operation?

1287

What is the use of jdftval in as400?

1472

What is performance tuning db2?

1126

Explain about maximum displacement?

1120

Name the various locking levels available?

1141

What are the two types of fields available in ims db?

1066

What is the use of the program list table?

1141

How many bytes does a s9(7) comp-3 field occupy ?

1013

What is database descriptor?

1083

WHAT IS FERERENTIAL INTRIGRITY ?

1694

What is the pic clause for the hhmmss type of data fields?

1011

What is db2 catalog database?

1099

What is the term conversational programs means?

1073

How to execute 2nd and 4th steps among 5 steps in jcl proc?

1420

How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?

1252

For More Un-Answered { MainFrame } Questions Click Here