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

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 5024

What does the sqlcode of -818 pertain to?

3 7574

How many clustering indexes can be defined for a table?

2 7097

What is tablespace?

3 6657

What is the function of the Data Manager?

2 5186

What is a SELECT statement?

1 4398

How do you define a correlated name?

1 3984

What is the self-referencing constraint?

2 6336

What is a buffer pool?

2 6466

What is the cascade rule and how does it relate to deletions made with a subselect?

1 5561

When is the results table for the query in a DECLARE CURSOR statement created?

5 9246

What does it mean if the null indicator has -1, 0, -2?

1 13577

What is meant by isolation level?

3 6793

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 6847

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 5157

Un-Answered Questions { MainFrame }

Explain the data storage?

993

For what purpose steplib and joblib are used ?

1138

Write some characteristics of cobol as means of business language.

1142

What is the difference between next sentence and continue in cobol programing language?

1220

What parameter directs the output of the job log dataset?

1276

In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?

1463

What is the best way to code to provide me the info that there are disks in the array failing or failed? How to code? Run in batch?

803

Name the three ways available for a program to position the cursor on the screen?

1085

what is arrival sequence?

1870

I have done a start browse on a vsam dataset. Can I do another start browse without doing an end browse?

1073

How to use the same COBOL program in Batch and CICS on lines? explain with an example

2385

What Is Ddm ?

1691

Differentiate between cs and rr isolation levels? Where do you specify them?

1066

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

1070

WHAT IS AS/400 SYNORIO?

3356

For More Un-Answered { MainFrame } Questions Click Here