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

How do you filter out the rows retrieved from a Db2 table ?

1 9363

What is a clustered index?

1 12534

When will you chose to run RUNSTATS?

1 9487

What does DML stand for and what are some examples of it?

IBM,

3 9851

What is meant by a unit of recovery?

1 6628

What is CHECK PENDING ?

5 20157

What is a thread?

3 8297

What is filter factor?

2 10805

What's the maximum number of volumes that can be added to a STOGROUP?

IBM,

1 9405

What are PACKAGES ?

3 9143

Which catalog tables contain authorization information?

1 6236

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 9818

How does one remove entries from the SCT02 table?

1 4683

what is the difference between join and union?

IBM,

4 19015

I use CS and update a page. Will the lock be released after I am done with that page?

2 9970

Un-Answered Questions { MainFrame }

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1562

How can we know running job is batch or interactive?

1189

suppose oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records in both files copy all the common records into oza017.myorg.xyz dataset?

1076

Is db2 free?

1153

List the different jcl statements that are not permitted in the procedures?

1136

What are the two ways in which dl/i interface can be invoked?

1009

Using alternate indexes in batch program?

1181

What is the difference between read work file 1 and read work file once? Why we are using work file once?

1034

What is the function of linear dataset in vsam?

1124

What is db2 command?

1097

What is the difference between bind and rebind in db2?

1523

Explain the catalog?

1044

What do you mean by hierarchical database?

1301

Which are the db2 tools to protect integrity of the database?

1172

how to display the negative numbers?

2394

For More Un-Answered { MainFrame } Questions Click Here