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 auditing?

2 5060

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 5141

When do you specify the isolation level? How?

1 5241

What do the initials DDL and DML stand for and what is their meaning?

2 5486

What is the error code -803 ?

3 11834

What can the SET option of the Repair Utility accomplish?

1 5598

What are the levels of isolation available with DB2V4

IBM,

2 4640

Where are plans stored?

2 7152

What is a clustering index?

2 5582

What is a Resource Control Table(RCT)? Describe its characteristics.

3 13581

How is the SUBSTR keyword used in sql?

1 9361

What is an inner join, and an outer join ?

CTA,

1 12956

Where is the access path logic created by the DB2 Optimizer stored?

1 8384

What is a root page?

1 4363

What happens to the PLAN if index used by it is dropped?

1 5783

Un-Answered Questions { MainFrame }

What is the purpose of dd * statement in jcl?

1303

what is the purpose of data structure?

1759

Define the term mro (multi region operation)?

1121

How does the jcl specify the job to os?

1168

What is dbdgen process?

1190

What is load replace in db2?

1008

explain the purpose of keep and assume keywords?

1829

Define data page.

1079

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

1050

Specify the requirements for automatic task initiation?

1024

Explain difference between read work file 1 and read work file once? Why we are using work file once?

978

Can a Search can be done on a table with or without Index?

1299

what will happen when you try to open an empty vsam file in a cobol program for input?

1065

Where can you declare a cursor in a cobol-db2 program?

1089

Explain dd statement in jcl?

1139

For More Un-Answered { MainFrame } Questions Click Here